trees
105 rows where SiteOrder = 2 and qSpecies_id = 133 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9249 | 183317 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.500875914404 | (37.7640002060456, -122.500875914404) | 1 | 8 | 3 | 56 | 35 | |||
168589 | 183679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.496998863919 | (37.7626128114068, -122.496998863919) | 1 | 8 | 3 | 56 | 35 | |||
10338 | 31751 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | 1 | 8 | 3 | 29491 | 35 | |
33901 | 183040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | 1 | 8 | 3 | 29491 | 35 | |||
110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
171037 | 182595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.7466767317389 | -122.4767165565 | (37.7466767317389, -122.4767165565) | 1 | 8 | 3 | 29491 | 35 | |||
14448 | 206509 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.7579816107664 | -122.474384202485 | (37.7579816107664, -122.474384202485) | 1 | 8 | 4 | 56 | 12 | |||
181480 | 206515 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.474057043516 | (37.7579963659675, -122.474057043516) | 1 | 8 | 4 | 56 | 12 | |||
148811 | 206520 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.471327688331 | (37.7453833337792, -122.471327688331) | 1 | 8 | 4 | 29491 | 40 | |||
104682 | 206566 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991741.26483 | 2097200.972 | 37.7380395382962 | -122.471079130991 | (37.7380395382962, -122.471079130991) | 1 | 8 | 4 | 29491 | 40 | |||
38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
152874 | 206525 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | 1 | 8 | 4 | 59 | 40 | |||
74614 | 206528 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | 1 | 8 | 4 | 59 | 40 | |||
151607 | 206507 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.466572955586 | (37.751190371338, -122.466572955586) | 1 | 8 | 4 | 29491 | 12 | |||
169106 | 206621 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993175.25671 | 2102431.10448 | 37.7524829903015 | -122.466501185193 | (37.7524829903015, -122.466501185193) | 1 | 8 | 4 | 29491 | 12 | |||
88461 | 206579 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257 | -122.465873376566 | (37.744949720257, -122.465873376566) | 1 | 8 | 4 | 29491 | 40 | |||
186101 | 206532 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993345.96317 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | 9 | 8 | 4 | 59 | 40 | |||
35595 | 206499 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993488.07663 | 2104571.64852 | 37.7583784177465 | -122.46557490416 | (37.7583784177465, -122.46557490416) | 1 | 8 | 4 | 56 | 12 | |||
189913 | 206581 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.7452103357006 | -122.464870033553 | (37.7452103357006, -122.464870033553) | 1 | 8 | 4 | 29491 | 40 | |||
133810 | 206583 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | 1 | 8 | 4 | 29491 | 40 | |||
172753 | 206576 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.7448642055102 | -122.464537875235 | (37.7448642055102, -122.464537875235) | 1 | 8 | 4 | 29491 | 40 | |||
152214 | 206574 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993698.09593 | 2099619.5133 | 37.7447932328356 | -122.464489006068 | (37.7447932328356, -122.464489006068) | 1 | 8 | 4 | 29491 | 40 | |||
157023 | 206592 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993721.8716 | 2099672.65516 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | 1 | 8 | 4 | 29491 | 40 | |||
61980 | 206497 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993722.38757 | 2104477.64501 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | 1 | 8 | 4 | 56 | 12 | |||
62897 | 206623 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | 1 | 8 | 4 | 29491 | 12 | |||
161052 | 206555 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.7490751632062 | -122.463926929805 | (37.7490751632062, -122.463926929805) | 1 | 8 | 4 | 29491 | 40 | |||
59731 | 206585 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993961.34204 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | 1 | 8 | 4 | 29491 | 40 | |||
117873 | 206667 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.7484063733597 | -122.463585995905 | (37.7484063733597, -122.463585995905) | 1 | 8 | 4 | 29491 | 40 | |||
193008 | 218121 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994024.91011 | 2100655.57636 | 37.7476568343048 | -122.463434125583 | (37.7476568343048, -122.463434125583) | 1 | 8 | 4 | 29491 | 40 | |||
77503 | 206587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.7452293284847 | -122.463301476481 | (37.7452293284847, -122.463301476481) | 1 | 8 | 4 | 29491 | 40 | |||
39404 | 206537 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | 1 | 8 | 4 | 29491 | 40 | |||
11337 | 206619 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994070.38957 | 2104649.56309 | 37.7586259201623 | -122.463566678468 | (37.7586259201623, -122.463566678468) | 1 | 5 | 4 | 56 | 12 | |||
17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
185629 | 122405 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
118462 | 206589 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994086.71603 | 2099812.25652 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | 1 | 8 | 4 | 29491 | 40 | |||
140646 | 206538 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 399 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994103.27732 | 2101446.93652 | 37.7498342233673 | -122.463220551898 | (37.7498342233673, -122.463220551898) | 1 | 8 | 4 | 29491 | 40 | |||
68672 | 206540 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.463105404514 | (37.7496241156629, -122.463105404514) | 1 | 8 | 4 | 29491 | 40 | |||
161629 | 206542 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994154.36407 | 2101104.38684 | 37.7488966118001 | -122.46301904262 | (37.7488966118001, -122.46301904262) | 1 | 8 | 4 | 29491 | 40 | |||
103756 | 206658 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | 1 | 8 | 4 | 29491 | 40 | |||
158137 | 206662 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994173.63187 | 2101468.04914 | 37.7498962460271 | -122.462978796147 | (37.7498962460271, -122.462978796147) | 1 | 8 | 4 | 29491 | 40 | |||
133847 | 206553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994206.92878 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | 1 | 8 | 4 | 29491 | 40 | |||
61748 | 206655 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994255.40167 | 2101538.85258 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | 1 | 8 | 4 | 29491 | 40 | |||
44186 | 206624 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994298.51296 | 2101800.25271 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | 1 | 8 | 4 | 29491 | 40 | |||
20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 | |||
84544 | 206550 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994328.73662 | 2100761.78102 | 37.7479659456765 | -122.462391220472 | (37.7479659456765, -122.462391220472) | 1 | 8 | 4 | 29491 | 40 | |||
55707 | 206642 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.462116437149 | (37.7480147959636, -122.462116437149) | 1 | 8 | 4 | 29491 | 40 | |||
70575 | 206546 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 265 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994442.89418 | 2100449.8026 | 37.747115904674 | -122.461973851414 | (37.747115904674, -122.461973851414) | 1 | 8 | 4 | 29491 | 40 | |||
185390 | 206632 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Castenada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994454.48924 | 2101216.21265 | 37.7492209405946 | -122.46198932515 | (37.7492209405946, -122.46198932515) | 1 | 8 | 4 | 29491 | 40 | |||
132095 | 206645 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994475.58114 | 2100840.87711 | 37.7481915783923 | -122.461889176638 | (37.7481915783923, -122.461889176638) | 1 | 8 | 4 | 29491 | 40 | |||
78570 | 206653 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994496.6283 | 2101014.48441 | 37.748669471824 | -122.46182898323 | (37.748669471824, -122.46182898323) | 1 | 8 | 4 | 29491 | 40 | |||
38300 | 206652 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994516.45103 | 2100943.31749 | 37.7484752065739 | -122.4617552775 | (37.7484752065739, -122.4617552775) | 1 | 8 | 4 | 29491 | 40 | |||
92575 | 206640 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994518.44354 | 2100835.02583 | 37.7481779797266 | -122.461740536702 | (37.7481779797266, -122.461740536702) | 1 | 8 | 4 | 29491 | 40 | |||
172212 | 206637 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 159 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994549.87925 | 2100894.15199 | 37.7483421347836 | -122.461636120028 | (37.7483421347836, -122.461636120028) | 1 | 8 | 4 | 29491 | 40 | |||
79407 | 206634 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.46207 | 2100915.67701 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | 1 | 8 | 4 | 29491 | 40 | |||
45462 | 206618 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | 1 | 8 | 4 | 59 | 40 | ||
117633 | 122387 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779324 | 5994732 | 2099337 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | 1 | 8 | 4 | 59 | 40 | |||
144713 | 206616 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.68039 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | 1 | 8 | 4 | 59 | 40 | ||
139066 | 206607 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2 Sola Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994975.69537 | 2100714.97086 | 37.7478746501056 | -122.460150689128 | (37.7478746501056, -122.460150689128) | 1 | 8 | 4 | 29491 | 40 | |||
25861 | 206613 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.7468124923186 | -122.459952623323 | (37.7468124923186, -122.459952623323) | 1 | 8 | 4 | 29491 | 40 | |||
162209 | 206598 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5995052.00135 | 2100847.98673 | 37.7482442669627 | -122.459896462476 | (37.7482442669627, -122.459896462476) | 1 | 8 | 4 | 29491 | 40 | |||
54562 | 206595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995084.10326 | 2100870.93077 | 37.7483091116899 | -122.459787117476 | (37.7483091116899, -122.459787117476) | 1 | 8 | 4 | 29491 | 40 | |||
158105 | 206674 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | 9 | 7 | 4 | 59 | 40 | |||
80109 | 206672 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995263.98331 | 2095214.43939 | 37.732788127969 | -122.458755649049 | (37.732788127969, -122.458755649049) | 9 | 7 | 4 | 59 | 40 | |||
66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
128797 | 206534 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.458312597175 | (37.7288535085691, -122.458312597175) | 9 | 7 | 4 | 28861 | 40 | |||
134750 | 206557 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995503.23656 | 2100160.44134 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | 1 | 5 | 4 | 59 | 40 | |||
180068 | 39661 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | 9 | 8 | 6 | 28861 | 24 | ||
117813 | 39659 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
20681 | 206679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | 9 | 7 | 4 | 59 | 40 | |||
21541 | 206683 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995995.17419 | 2096006.34018 | 37.7350044954584 | -122.456284991974 | (37.7350044954584, -122.456284991974) | 9 | 7 | 4 | 59 | 40 | |||
111864 | 206687 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996087.44674 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | 9 | 7 | 4 | 59 | 40 | |||
21549 | 94071 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
9795 | 94076 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
127288 | 206690 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245 | (37.7348932897948, -122.45581025245) | 9 | 7 | 4 | 59 | 40 | |||
86717 | 206692 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996416.06092 | 2095880.87144 | 37.7346841407625 | -122.454820783252 | (37.7346841407625, -122.454820783252) | 9 | 7 | 4 | 59 | 40 | |||
48825 | 116196 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
91240 | 51948 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48172 | 5996897.19536074 | 2106034.05471344 | 37.7625898542367 | -122.453890338129 | (37.7625898542367, -122.453890338129) | 15 | 5 | 11 | 29492 | 12 | ||||
119257 | 223030 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.7595064230002 | -122.450164233094 | (37.7595064230002, -122.450164233094) | 15 | 5 | 11 | 28862 | 12 | |||
72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
62246 | 121661 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
154287 | 41697 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
59033 | 126376 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 122 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001336.2876 | 2121154.5777 | 37.8043604581295 | -122.439621194774 | (37.8043604581295, -122.439621194774) | 13 | 9 | 1 | 57 | 17 | |||
34876 | 45122 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
20331 | 95111 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.7278683408513 | -122.436360947301 | (37.7278683408513, -122.436360947301) | 9 | 7 | 6 | 28861 | 25 |
144447 | 223037 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002071.56022 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | 2 | 7 | 5 | 63 | 7 | |||
48817 | 41708 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.435194188204 | (37.7355450223799, -122.435194188204) | 2 | 7 | 5 | 63 | 7 | ||
14146 | 41229 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41935 | 6002621.77288 | 2121066.97203 | 37.8041929962699 | -122.435166401228 | (37.8041929962699, -122.435166401228) | 13 | 9 | 1 | 57 | 17 |
142629 | 51536 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
165895 | 42999 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
178314 | 223033 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006248.27078 | 2096110.49551 | 37.7358737315714 | -122.420843728155 | (37.7358737315714, -122.420843728155) | 2 | 7 | 7 | 28859 | 2 | |||
155068 | 255587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
32898 | 51448 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | 2 | 7 | 7 | 28859 | 2 | |||
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
123767 | 223041 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 408 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 776709 | 6007256.61829 | 2097259.39898 | 37.7390851512711 | -122.417438860719 | (37.7390851512711, -122.417438860719) | 2 | 7 | 7 | 28859 | 2 | ||
187759 | 126384 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1120 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6007500.24433 | 2119896.23774 | 37.8012542708165 | -122.418200985801 | (37.8012542708165, -122.418200985801) | 5 | 1 | 1 | 28858 | 32 | ||||
8188 | 126379 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007507.74968 | 2119357.27743 | 37.7997748437807 | -122.418136782297 | (37.7997748437807, -122.418136782297) | 5 | 1 | 1 | 28858 | 32 | |||
171276 | 223044 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | 2 | 7 | 7 | 28859 | 2 | |||
157257 | 223043 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008381.78974 | 2096055.87054 | 37.7358437688638 | -122.413463422917 | (37.7358437688638, -122.413463422917) | 10 | 7 | 7 | 28859 | 2 | |||
87754 | 43489 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 731 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43170 | 6008504.61569086 | 2095547.09041526 | 37.7344536647683 | -122.413002801242 | (37.7344536647683, -122.413002801242) | 10 | 7 | 7 | 28859 | 2 | ||
119767 | 84504 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 650X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2006 12:00:00 AM | 3 | 3x3 | 6009485.16866501 | 2110503.49163991 | 37.7755755804602 | -122.410668559049 | (37.7755755804602, -122.410668559049) | 8 | 2 | 9 | 28853 | 34 |
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) );