trees
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9993 | 47292 | 7 | 333 | 2801x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | 2 | FUF | 08/16/2002 12:00:00 AM | Permit Number 45232 | 6009524 | 2104958 | 37.7603511166103 | -122.410142631678 | (37.7603511166103, -122.410142631678) | 2 | 4 | 7 | 28859 | 19 | ||
| 31159 | 221969 | 1 | 333 | 3900 22nd St | 9 | Sidewalk: Curb side : Pot | Tree | 2 | 5 | Width 4ft | 6002406.82062 | 2102995.69652 | 37.7545616068583 | -122.434617293171 | (37.7545616068583, -122.434617293171) | 2 | 4 | 5 | 28862 | 22 | |||
| 36736 | 101527 | 6 | 333 | 151-153 Lower Ter | 1 | Front Yard : Yard | Tree | 2 | 18 | Permit Number 769490 | 6000139.7 | 2106146.6 | 37.7630842500585 | -122.4426838025 | (37.7630842500585, -122.4426838025) | 15 | 5 | 5 | 28862 | 3 | |||
| 67155 | 187969 | 1 | 333 | 1630 Jerrold Ave | 1 | : | Tree | 2 | 5 | Width 3ft | 6015189.03434 | 2097156.64279 | 37.7392461326034 | -122.390004769231 | (37.7392461326034, -122.390004769231) | 10 | 3 | 8 | 58 | 1 | |||
| 71457 | 215470 | 1 | 333 | 2 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | 2 | 17 | Width 4ft | 5994985.87708 | 2100710.42792 | 37.7478627619652 | -122.460115152419 | (37.7478627619652, -122.460115152419) | 1 | 8 | 4 | 29491 | 40 | |||
| 105473 | 187968 | 1 | 333 | 600 Illinois St | 3 | Sidewalk: Curb side : Pot | Tree | 2 | 10 | Width 3ft | 6015942.9159 | 2106228.07287 | 37.7641961608518 | -122.388031024433 | (37.7641961608518, -122.388031024433) | 14 | 3 | 8 | 28856 | 29 | |||
| 107229 | 255805 | 6 | 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
| 130003 | 187970 | 1 | 333 | 1630 Jerrold Ave | 2 | : | Tree | 2 | 5 | Width 3ft | 6015180.35371 | 2097164.4459 | 37.7392670769075 | -122.390035328173 | (37.7392670769075, -122.390035328173) | 10 | 3 | 8 | 58 | 1 | |||
| 167607 | 221970 | 1 | 333 | 3900 22nd St | 10 | Sidewalk: Curb side : Pot | Tree | 2 | 5 | Width 4ft | 6002405.12131 | 2102995.45063 | 37.7545608352344 | -122.434623152247 | (37.7545608352344, -122.434623152247) | 2 | 4 | 5 | 28862 | 22 | |||
| 185733 | 175228 | 1 | 333 | 102 France Ave | 7 | Sidewalk: Property side : Yard | Tree | 2 | 3 | Width 1ft | 6001368.13444 | 2090223.95068 | 37.7194343448899 | -122.437294890573 | (37.7194343448899, -122.437294890573) | 9 | 7 | 6 | 28861 | 5 |