[data.sfgov.org/yhqp-riqs] Question about "Street Sweeping Schedule"

[gilles-yvetot]

API Docs: https://dev.socrata.com/foundry/data.sfgov.org/yhqp-riqs

I am trying to use the street sweeping schedule API but it looks like they are duplicates:

[{
    cnn: '3442000',
    corridor: 'Bush St',
    limits: 'Hyde St  -  Larkin St',
    cnnrightleft: 'R',
    blockside: 'North',
    fullname: 'Monday',
    weekday: 'Mon',
    fromhour: '7',
    tohour: '9',
    week1: '1',
    week2: '1',
    week3: '1',
    week4: '1',
    week5: '1',
    holidays: '0',
    blocksweepid: '1629330',
    line: { type: 'LineString', coordinates: [Array] }
  },
 {
    cnn: '3442000',
    corridor: 'Bush St',
    limits: 'Hyde St  -  Larkin St',
    cnnrightleft: 'R',
    blockside: 'North',
    fullname: 'Friday',
    weekday: 'Fri',
    fromhour: '7',
    tohour: '9',
    week1: '1',
    week2: '1',
    week3: '1',
    week4: '1',
    week5: '1',
    holidays: '0',
    blocksweepid: '1629349',
    line: { type: 'LineString', coordinates: [Array] }
  }
]

Maybe there is something I am not understanding here. Both items are for the same street, same side of the sidewalk but they have different times.

[bungee1980]

one is for friday one is for monday. so on that section of bush st. its monday and friday 7-9. although for that street heading into downtown, it is probably every day. check to see if there are other objects for the other weekdays.

[gilles-yvetot]

@bungee1980 thanks a lot! I didn't realize it was twice a week, the sign in the street only say Monday though

[bungee1980]

it's 3 times a week. 2 on north side. one on south side. the south side only says wednesday, the north side says monday and friday. curl https://data.sfgov.org/resource/yhqp-riqs.json?cnn=3442000

[
  {
    "cnn": "3442000",
    "corridor": "Bush St",
    "limits": "Hyde St  -  Larkin St",
    "cnnrightleft": "L",
    "blockside": "South",
    "fullname": "Wednesday",
    "weekday": "Wed",
    "fromhour": "6",
    "tohour": "8",
    "week1": "1",
    "week2": "1",
    "week3": "1",
    "week4": "1",
    "week5": "1",
    "holidays": "0",
    "blocksweepid": "1629314",
    "line": {
      "type": "LineString",
      "coordinates": [
        [
          -122.417016878024,
          37.789110175732
        ],
        [
          -122.418655872543,
          37.788909612202
        ]
      ]
    }
  },
  {
    "cnn": "3442000",
    "corridor": "Bush St",
    "limits": "Hyde St  -  Larkin St",
    "cnnrightleft": "R",
    "blockside": "North",
    "fullname": "Friday",
    "weekday": "Fri",
    "fromhour": "7",
    "tohour": "9",
    "week1": "1",
    "week2": "1",
    "week3": "1",
    "week4": "1",
    "week5": "1",
    "holidays": "0",
    "blocksweepid": "1629349",
    "line": {
      "type": "LineString",
      "coordinates": [
        [
          -122.417016878024,
          37.789110175732
        ],
        [
          -122.418655872543,
          37.788909612202
        ]
      ]
    }
  },
  {
    "cnn": "3442000",
    "corridor": "Bush St",
    "limits": "Hyde St  -  Larkin St",
    "cnnrightleft": "R",
    "blockside": "North",
    "fullname": "Monday",
    "weekday": "Mon",
    "fromhour": "7",
    "tohour": "9",
    "week1": "1",
    "week2": "1",
    "week3": "1",
    "week4": "1",
    "week5": "1",
    "holidays": "0",
    "blocksweepid": "1629330",
    "line": {
      "type": "LineString",
      "coordinates": [
        [
          -122.417016878024,
          37.789110175732
        ],
        [
          -122.418655872543,
          37.788909612202
        ]
      ]
    }
  }
]

[gilles-yvetot]

That makes more sense!