trees
252 rows where qSpecies_id = 195 sorted by rowid descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193935 | 126409 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1920 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004775.53242 | 2116016.61179 | 37.7904480629696 | -122.42735316234 | (37.7904480629696, -122.42735316234) | 13 | 9 | 1 | 28858 | 27 | |||
193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 | ||||
193310 | 223678 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002810.88553 | 2100958.91047 | 37.7489920046987 | -122.43307441627 | (37.7489920046987, -122.43307441627) | 2 | 4 | 5 | 28862 | 22 | |||
193244 | 91476 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
193080 | 32758 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
192687 | 33995 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521 | (37.7442517881202, -122.40634471521) | 2 | 7 | 7 | 28859 | 2 | ||
192487 | 176087 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011745.86132 | 2086717.65639 | 37.710391258824 | -122.401176451643 | (37.710391258824, -122.401176451643) | 10 | 3 | 8 | 309 | 1 | |||
191494 | 240691 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2762 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780708 | 6010175.82861 | 2102832.96538 | 37.7545527620063 | -122.407738408027 | (37.7545527620063, -122.407738408027) | 2 | 4 | 7 | 28859 | 19 | |
191477 | 45080 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2131 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 2 | Permit Number 43963 | 5987257.3685 | 2100779.0687 | 37.7476036774768 | -122.486844665894 | (37.7476036774768, -122.486844665894) | 1 | 8 | 3 | 29491 | 35 | |
190330 | 202156 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1925 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6013109.74623 | 2093393.80545 | 37.7287986220599 | -122.396930316988 | (37.7287986220599, -122.396930316988) | 10 | 3 | 8 | 58 | 1 | |||
189722 | 16067 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 236 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6000426.63236 | 2094704.03312 | 37.7316820562622 | -122.44087051766 | (37.7316820562622, -122.44087051766) | 9 | 7 | 4 | 63 | 40 | |||
188905 | 206792 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2468 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5992061.76726 | 2098654.75927 | 37.7420498014689 | -122.470076832981 | (37.7420498014689, -122.470076832981) | 1 | 8 | 4 | 29491 | 40 | |||
188770 | 42744 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
188119 | 18923 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2671 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2000 12:00:00 AM | 6 | 4X4 | 6002050.10915 | 2115698.07724 | 37.7894189336721 | -122.436760123981 | (37.7894189336721, -122.436760123981) | 13 | 6 | 1 | 29490 | 27 | ||
187114 | 223669 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007464.47007 | 2098181.71647 | 37.741629323436 | -122.416785526654 | (37.741629323436, -122.416785526654) | 2 | 7 | 7 | 28859 | 2 | |||
186902 | 16078 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 259 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000361.52828 | 2094624.99064 | 37.7314613158879 | -122.44108992617 | (37.7314613158879, -122.44108992617) | 9 | 7 | 4 | 63 | 40 | |||
186749 | 100279 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 3460X 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007182 | 2104415 | 37.7587286142457 | -122.418204039558 | (37.7587286142457, -122.418204039558) | 2 | 4 | 7 | 28859 | 19 | |||
185240 | 223275 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 57 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6007321.82644 | 2099172.60178 | 37.7443420492586 | -122.417348945606 | (37.7443420492586, -122.417348945606) | 2 | 7 | 7 | 28859 | 2 | |||
185012 | 258221 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006999 | 2095654 | 37.73466258188 | -122.418215799693 | (37.73466258188, -122.418215799693) | 2 | 7 | 7 | 28859 | 2 | ||||
184828 | 202154 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1937 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6013078.37637 | 2093416.60548 | 37.7288594800651 | -122.397040363418 | (37.7288594800651, -122.397040363418) | 10 | 3 | 8 | 58 | 1 | |||
184805 | 91471 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
184288 | 46131 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44481 | 5997450.10216271 | 2107762.76782376 | 37.7673681457069 | -122.452102777266 | (37.7673681457069, -122.452102777266) | 15 | 5 | 11 | 29492 | 9 | ||
184059 | 88671 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016898.17998 | 2102118.14564 | 37.7529640448765 | -122.384440730253 | (37.7529640448765, -122.384440730253) | 10 | 3 | 8 | 58 | 1 | |
183731 | 42749 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
183379 | 42747 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
182822 | 126405 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2501 Jackson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001610.61538 | 2116620.32989 | 37.7919262138789 | -122.438346819448 | (37.7919262138789, -122.438346819448) | 13 | 6 | 1 | 29490 | 27 | |||
180249 | 16056 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 219 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000606.99528 | 2094621.48132 | 37.7314656586978 | -122.440241050681 | (37.7314656586978, -122.440241050681) | 9 | 7 | 4 | 63 | 40 | |||
178393 | 16068 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 241 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000456.47013 | 2094623.33768 | 37.731462184614 | -122.440761576495 | (37.731462184614, -122.440761576495) | 9 | 7 | 4 | 63 | 40 | |||
178037 | 100278 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 3460X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007182 | 2104415 | 37.7587286142457 | -122.418204039558 | (37.7587286142457, -122.418204039558) | 2 | 4 | 7 | 28859 | 19 | |||
177870 | 126404 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2501 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001524.31807 | 2116606.64238 | 37.7918837227069 | -122.438644426709 | (37.7918837227069, -122.438644426709) | 13 | 6 | 1 | 29490 | 27 | |||
177645 | 121761 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779456 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |
176450 | 2539 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1575 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/05/1999 12:00:00 AM | 3 | 3X3 | 6016305.53274 | 2099035.35536 | 37.7444665522926 | -122.386275327464 | (37.7444665522926, -122.386275327464) | 10 | 3 | 8 | 58 | 1 | ||
176191 | 202202 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1956 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013055.77305 | 2093504.05261 | 37.7290983337043 | -122.397124634419 | (37.7290983337043, -122.397124634419) | 10 | 3 | 8 | 58 | 1 | |||
175382 | 36943 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 152 03rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994926.19435 | 2114520.78784 | 37.7857789756862 | -122.461322514651 | (37.7857789756862, -122.461322514651) | 11 | 6 | 1 | 54 | 11 | |
174635 | 202158 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1913 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6013140.94695 | 2093368.78005 | 37.7287316441256 | -122.396820699517 | (37.7287316441256, -122.396820699517) | 10 | 3 | 8 | 58 | 1 | |||
174568 | 91473 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
173705 | 91475 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
173235 | 16084 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 273 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000289.15612 | 2094627.44091 | 37.7314639212218 | -122.441340305536 | (37.7314639212218, -122.441340305536) | 9 | 7 | 4 | 63 | 40 | |||
172412 | 176084 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011735.35451 | 2086672.51042 | 37.7102667108031 | -122.401209595273 | (37.7102667108031, -122.401209595273) | 10 | 3 | 8 | 309 | 1 | |||
170278 | 126410 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1920 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004771.88158 | 2116049.56275 | 37.790538331527 | -122.427368142329 | (37.790538331527, -122.427368142329) | 13 | 9 | 1 | 28858 | 27 | |||
169699 | 223272 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 90 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004552.00541 | 2101644.43892 | 37.7509729161719 | -122.427102433147 | (37.7509729161719, -122.427102433147) | 2 | 4 | 5 | 28862 | 22 | |||
168660 | 35259 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | 5 | 9 | 1 | 28858 | 32 | ||
168478 | 126406 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2451 Steiner St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002291.50038 | 2116148.81234 | 37.7906702521829 | -122.435957203858 | (37.7906702521829, -122.435957203858) | 13 | 9 | 1 | 29490 | 27 | |||
166680 | 14638 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 600X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4x4 | 6006218.48413 | 2112159.25458 | 37.7799382114304 | -122.422086486016 | (37.7799382114304, -122.422086486016) | 7 | 9 | 11 | 28852 | 41 | |||
166095 | 223269 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010823.03156 | 2102440.75531 | 37.7535120494589 | -122.405472576922 | (37.7535120494589, -122.405472576922) | 10 | 4 | 8 | 28859 | 19 | |||
166036 | 223681 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002667.71298 | 2100952.64567 | 37.7489666806705 | -122.433569059575 | (37.7489666806705, -122.433569059575) | 2 | 4 | 5 | 28862 | 22 | |||
165671 | 33418 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 498X KENWOOD WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404 | 2093661 | 37.7284156834141 | -122.465073241063 | (37.7284156834141, -122.465073241063) | 9 | 8 | 4 | 59 | 40 | |
164982 | 16070 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 251 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000403.76361 | 2094624.43092 | 37.731462184634 | -122.440943870862 | (37.731462184634, -122.440943870862) | 9 | 7 | 4 | 63 | 40 | |||
163873 | 223671 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007506.0274 | 2098173.94158 | 37.7416103126682 | -122.41664128438 | (37.7416103126682, -122.41664128438) | 2 | 7 | 7 | 28859 | 2 | |||
163805 | 33431 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37535 | 5999930.67607914 | 2095733.95298446 | 37.7344817167018 | -122.442659055518 | (37.7344817167018, -122.442659055518) | 9 | 7 | 4 | 63 | 40 | ||
162782 | 42753 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
162640 | 248034 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010483.27046 | 2099064.93889 | 37.7442237946989 | -122.406409700143 | (37.7442237946989, -122.406409700143) | 2 | 7 | 7 | 28859 | 2 | |||
162398 | 42048 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 214 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42365 | 6005128.75403076 | 2099926.75275442 | 37.746289143211 | -122.424985780451 | (37.746289143211, -122.424985780451) | 2 | 7 | 5 | 63 | 22 | |||
161978 | 16091 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 284 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000198.5480309 | 2094712.9146898 | 37.7316934502774 | -122.44165968578 | (37.7316934502774, -122.44165968578) | 9 | 7 | 4 | 63 | 40 | |||
161526 | 202198 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1998 Armstrong Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6012950.89039 | 2093587.34994 | 37.7293212117817 | -122.397493064171 | (37.7293212117817, -122.397493064171) | 10 | 3 | 8 | 58 | 1 | |||
160820 | 256315 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006234 | 2121009 | 37.8042382772915 | -122.422661874451 | (37.8042382772915, -122.422661874451) | 5 | 9 | 1 | 28858 | 32 | ||||
160001 | 45418 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3690 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.453783416263 | (37.7891914436893, -122.453783416263) | 11 | 6 | 1 | 54 | 31 | |||
158500 | 223667 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 10 Gladys St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005813.9989 | 2097648.11236 | 37.7400711958267 | -122.422454401347 | (37.7400711958267, -122.422454401347) | 2 | 7 | 7 | 28859 | 2 | |||
156541 | 42751 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
156404 | 176091 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011761.10909 | 2086779.81535 | 37.7105627856051 | -122.401128116692 | (37.7105627856051, -122.401128116692) | 10 | 3 | 8 | 309 | 1 | |||
155813 | 34212 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.7443573485467 | -122.406767634166 | (37.7443573485467, -122.406767634166) | 2 | 7 | 7 | 28859 | 2 | ||
155793 | 223673 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003155.02499 | 2100979.47197 | 37.7490679767212 | -122.431885848858 | (37.7490679767212, -122.431885848858) | 2 | 4 | 5 | 28862 | 22 | |||
155490 | 32528 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.7347690834472 | -122.418026418979 | (37.7347690834472, -122.418026418979) | 2 | 7 | 7 | 28859 | 2 | ||
155057 | 248033 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010558.59528 | 2099039.59827 | 37.7441584283672 | -122.406147456957 | (37.7441584283672, -122.406147456957) | 2 | 7 | 7 | 28859 | 2 | |||
154150 | 206794 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 106 Thrift St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5995856.77369 | 2089647.23467 | 37.7175359677947 | -122.456303835451 | (37.7175359677947, -122.456303835451) | 9 | 8 | 6 | 28861 | 24 | |||
153786 | 223280 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003505.67831 | 2096373.72104 | 37.7364415203469 | -122.430344725633 | (37.7364415203469, -122.430344725633) | 2 | 7 | 5 | 63 | 7 | |||
153648 | 176090 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.62292 | 2086765.56215 | 37.7105234546691 | -122.401139164846 | (37.7105234546691, -122.401139164846) | 10 | 3 | 8 | 309 | 1 | |||
152219 | 42752 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
148638 | 45419 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3690 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.453783416263 | (37.7891914436893, -122.453783416263) | 11 | 6 | 1 | 54 | 31 | |||
146068 | 33419 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 498X KENWOOD WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404 | 2093661 | 37.7284156834141 | -122.465073241063 | (37.7284156834141, -122.465073241063) | 9 | 8 | 4 | 59 | 40 | |
144690 | 223668 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 10 Gladys St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005828.64048 | 2097671.05304 | 37.740135011734 | -122.422405406283 | (37.740135011734, -122.422405406283) | 2 | 7 | 7 | 28859 | 2 | |||
144688 | 202145 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1991 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6012926.39508 | 2093534.52233 | 37.7291747940604 | -122.397574043633 | (37.7291747940604, -122.397574043633) | 10 | 3 | 8 | 58 | 1 | |||
144459 | 202155 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1931 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013085.35579 | 2093411.26351 | 37.7288452006287 | -122.397015860514 | (37.7288452006287, -122.397015860514) | 10 | 3 | 8 | 58 | 1 | |||
143942 | 121793 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6012186.53897 | 2104166.90751 | 37.7583278299834 | -122.400878511655 | (37.7583278299834, -122.400878511655) | 10 | 3 | 8 | 28856 | 29 | ||||
141847 | 16064 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 239 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000482.86247 | 2094624.68801 | 37.7314673953084 | -122.440670430219 | (37.7314673953084, -122.440670430219) | 9 | 7 | 4 | 63 | 40 | |||
141790 | 223679 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002778.97625 | 2100958.54485 | 37.7489891907177 | -122.433184732513 | (37.7489891907177, -122.433184732513) | 2 | 4 | 5 | 28862 | 22 | |||
141393 | 16089 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 281 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000204.67262 | 2094627.92858 | 37.7314604471408 | -122.441632415216 | (37.7314604471408, -122.441632415216) | 9 | 7 | 4 | 63 | 40 | |||
141166 | 67529 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 662 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 13 | Permit Number 31067 | 6013257.86111 | 2104004.0948 | 37.7579404811792 | -122.397161966172 | (37.7579404811792, -122.397161966172) | 10 | 3 | 8 | 28856 | 29 | |
140978 | 223682 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3952 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004131.52495 | 2101329.89232 | 37.7500854579739 | -122.428534077398 | (37.7500854579739, -122.428534077398) | 2 | 4 | 5 | 28862 | 22 | |||
140419 | 202157 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1919 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013116.58632 | 2093387.72348 | 37.7287823029563 | -122.39690624394 | (37.7287823029563, -122.39690624394) | 10 | 3 | 8 | 58 | 1 | |||
139981 | 223675 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002987.60532 | 2100970.11932 | 37.7490328042407 | -122.43246411922 | (37.7490328042407, -122.43246411922) | 2 | 4 | 5 | 28862 | 22 | |||
139571 | 88664 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016498.80939 | 2102095.90957 | 37.7528808971534 | -122.385820292998 | (37.7528808971534, -122.385820292998) | 10 | 3 | 8 | 58 | 1 | |
138523 | 36944 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 152 03rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994925.42579 | 2114533.20025 | 37.7858130125762 | -122.461326073754 | (37.7858130125762, -122.461326073754) | 11 | 6 | 1 | 54 | 11 | |
137913 | 124368 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 91 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5996182.82999 | 2113897.83552 | 37.7841407574016 | -122.456929862505 | (37.7841407574016, -122.456929862505) | 11 | 6 | 1 | 54 | 31 | |||
137876 | 88660 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016339.82415 | 2102089.15306 | 37.7528535460529 | -122.386369627673 | (37.7528535460529, -122.386369627673) | 10 | 3 | 8 | 58 | 1 | |
136207 | 223271 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1301 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010084.63709 | 2101573.03413 | 37.7510881652043 | -122.407964929261 | (37.7510881652043, -122.407964929261) | 2 | 4 | 7 | 28859 | 19 | |||
135713 | 223680 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002752.1891 | 2100957.04892 | 37.748983563648 | -122.433277255656 | (37.748983563648, -122.433277255656) | 2 | 4 | 5 | 28862 | 22 | |||
134751 | 121762 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
132829 | 52142 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.422518914141 | (37.7400500494445, -122.422518914141) | 2 | 7 | 7 | 28859 | 2 | ||
132035 | 32760 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 |
132014 | 42748 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
130961 | 202159 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1907 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013147.17786 | 2093363.32947 | 37.7287170247605 | -122.39679877675 | (37.7287170247605, -122.39679877675) | 10 | 3 | 8 | 58 | 1 | |||
130264 | 67387 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 772 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | 6 | Permit Number 30884 | 5990710.63747 | 2110145.5351 | 37.7735222222582 | -122.475587411896 | (37.7735222222582, -122.475587411896) | 11 | 6 | 2 | 54 | 26 | |
130064 | 190952 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6012228.79731 | 2104083.07063 | 37.7580999894276 | -122.400726473151 | (37.7580999894276, -122.400726473151) | 10 | 3 | 8 | 28856 | 29 | |||
127542 | 91474 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
127293 | 248031 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010398.33522 | 2099063.65948 | 37.7442155299264 | -122.406703299111 | (37.7442155299264, -122.406703299111) | 2 | 7 | 7 | 28859 | 2 | |||
126478 | 120448 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 5 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988914.05514 | 2114983.86125 | 37.7867025962414 | -122.482156513118 | (37.7867025962414, -122.482156513118) | 11 | 6 | 1 | 55 | 33 | |||
126447 | 67504 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 477 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31033 | 5997603.60235184 | 2094078.4650037 | 37.729803210873 | -122.450585167202 | (37.729803210873, -122.450585167202) | 9 | 7 | 4 | 28861 | 40 | ||
126247 | 223281 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005792.08982 | 2097609.55014 | 37.7399640766707 | -122.422527414631 | (37.7399640766707, -122.422527414631) | 2 | 7 | 7 | 28859 | 2 | |||
125537 | 16086 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 279 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000243.09762 | 2094627.44767 | 37.7314613158742 | -122.441499538567 | (37.7314613158742, -122.441499538567) | 9 | 7 | 4 | 63 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );