trees
3,267 rows where qSpecies_id = 67 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168904 | 175631 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011388.92797 | 2089147.79242 | 37.7170440044489 | -122.402580872525 | (37.7170440044489, -122.402580872525) | 10 | 7 | 8 | 309 | 39 | |||
119061 | 205870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Lakeview Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997419.74541 | 2089183.01907 | 37.7163509392228 | -122.450867930105 | (37.7163509392228, -122.450867930105) | 9 | 8 | 6 | 28861 | 24 | |||
152330 | 175632 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011331.17878 | 2089183.91608 | 37.7171399684097 | -122.402783023943 | (37.7171399684097, -122.402783023943) | 10 | 7 | 8 | 309 | 39 | |||
193028 | 175654 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | 1 | 8 | 4 | 64 | 14 | ||||
98366 | 55331 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.30087 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | 10 | 7 | 8 | 309 | 39 | ||
24420 | 55329 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | 10 | 7 | 8 | 309 | 39 | ||
44905 | 1098 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999519.61819 | 2089252.78521 | 37.7166624877513 | -122.443614779103 | (37.7166624877513, -122.443614779103) | 9 | 7 | 6 | 28861 | 25 | |||
41896 | 204368 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 504 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993515.00932 | 2089252.8539 | 37.7163183837543 | -122.464369561706 | (37.7163183837543, -122.464369561706) | 9 | 8 | 6 | 64 | 24 | |||
14659 | 55328 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.54063 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | 10 | 7 | 8 | 309 | 39 | ||
40624 | 106717 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201X Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011633.03626 | 2089278.76713 | 37.7174172599795 | -122.401746303446 | (37.7174172599795, -122.401746303446) | 10 | 7 | 8 | 309 | 39 | |||
147209 | 55323 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | 10 | 7 | 8 | 309 | 39 | ||
68279 | 175655 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989994.06268 | 2089291.62254 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | 1 | 8 | 4 | 64 | 14 | ||||
71124 | 205850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.462541222916 | (37.7164641180118, -122.462541222916) | 9 | 8 | 6 | 28861 | 24 | |||
97460 | 205849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994041.34174 | 2089295.54399 | 37.7164659256374 | -122.46255340963 | (37.7164659256374, -122.46255340963) | 9 | 8 | 6 | 28861 | 24 | |||
40261 | 205848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994034.73412 | 2089295.68258 | 37.7164659256424 | -122.462576258696 | (37.7164659256424, -122.462576258696) | 9 | 8 | 6 | 28861 | 24 | |||
141737 | 205871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 111 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991654.88774 | 2089307.44903 | 37.7163608911211 | -122.470802959995 | (37.7163608911211, -122.470802959995) | 9 | 8 | 6 | 64 | 24 | |||
162306 | 61035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 208 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 13 | Permit Number 20858 | 6011595.89338 | 2089312.04675 | 37.7175065662474 | -122.40187702801 | (37.7175065662474, -122.40187702801) | 10 | 7 | 8 | 309 | 39 | ||
55188 | 175656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990014.12726 | 2089314.59531 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | 1 | 8 | 4 | 64 | 14 | ||||
35782 | 205854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 293 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994120.5161 | 2089316.03837 | 37.7165267575898 | -122.462281231613 | (37.7165267575898, -122.462281231613) | 9 | 8 | 6 | 28861 | 24 | |||
60554 | 205855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 289 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994148.42525 | 2089316.11897 | 37.7165285859025 | -122.462184770318 | (37.7165285859025, -122.462184770318) | 9 | 8 | 6 | 28861 | 24 | |||
147725 | 205853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 295 Montana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994093.80103 | 2089317.26449 | 37.7165285858993 | -122.462373660324 | (37.7165285858993, -122.462373660324) | 9 | 8 | 6 | 28861 | 24 | |||
193999 | 205852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 295 Montana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994085.70454 | 2089317.72121 | 37.7165293737121 | -122.462401678704 | (37.7165293737121, -122.462401678704) | 9 | 8 | 6 | 28861 | 24 | |||
174670 | 205851 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 295 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994081.91181 | 2089317.73328 | 37.7165291884491 | -122.462414789036 | (37.7165291884491, -122.462414789036) | 9 | 8 | 6 | 28861 | 24 | |||
161769 | 205860 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996072.4315 | 2089323.24068 | 37.7166587339933 | -122.455535005044 | (37.7166587339933, -122.455535005044) | 9 | 8 | 6 | 28861 | 24 | |||
95351 | 205862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996022.66258 | 2089323.51049 | 37.7166566187968 | -122.455707049864 | (37.7166566187968, -122.455707049864) | 9 | 8 | 6 | 28861 | 24 | |||
35607 | 205859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 70 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5996096.42731 | 2089323.76634 | 37.7166615542625 | -122.455452101947 | (37.7166615542625, -122.455452101947) | 9 | 8 | 6 | 28861 | 24 | |||
158214 | 205863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 84 Montana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995979.08585 | 2089323.90741 | 37.7166552077522 | -122.455857700672 | (37.7166552077522, -122.455857700672) | 9 | 8 | 6 | 28861 | 24 | |||
18532 | 205861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996047.17386 | 2089324.02533 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | 9 | 8 | 6 | 28861 | 24 | |||
150300 | 44345 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2001 12:00:00 AM | 3x3 | Permit Number 43728 | 5996130.57054216 | 2089332.51676928 | 37.7166875400006 | -122.455334718534 | (37.7166875400006, -122.455334718534) | 9 | 8 | 6 | 28861 | 24 | ||
145568 | 55327 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | Permit Number 11257 | 6011659.22686105 | 2089335.34929904 | 37.717574084708 | -122.401659748875 | (37.717574084708, -122.401659748875) | 10 | 7 | 8 | 309 | 39 | |||
136736 | 175637 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011646.28852 | 2089340.42458 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | 10 | 7 | 8 | 309 | 39 | |||
43539 | 175599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 192 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6004164.31837 | 2089345.24941 | 37.7171801843089 | -122.427566943762 | (37.7171801843089, -122.427566943762) | 9 | 7 | 6 | 28861 | 5 | |||
155176 | 205856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 286 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994153.26776 | 2089347.39588 | 37.7166147436609 | -122.462170299322 | (37.7166147436609, -122.462170299322) | 9 | 8 | 6 | 28861 | 24 | |||
184574 | 205869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 118 Lakeview Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997252.76199 | 2089357.29362 | 37.7168198961062 | -122.451457665965 | (37.7168198961062, -122.451457665965) | 9 | 8 | 6 | 28861 | 24 | |||
85794 | 204369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 527 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.16274 | 2089373.74444 | 37.7166484844088 | -122.464488410726 | (37.7166484844088, -122.464488410726) | 9 | 8 | 6 | 64 | 24 | |||
192880 | 175657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5990127.49163 | 2089397.98883 | 37.7165210414792 | -122.476088939347 | (37.7165210414792, -122.476088939347) | 1 | 8 | 4 | 64 | 14 | ||||
95653 | 204370 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 531 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993483.30762 | 2089398.8506 | 37.7167174282511 | -122.464489731835 | (37.7167174282511, -122.464489731835) | 9 | 8 | 6 | 64 | 24 | |||
35778 | 205864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 714 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995928.91835 | 2089403.79858 | 37.7168716907653 | -122.456036876198 | (37.7168716907653, -122.456036876198) | 9 | 8 | 6 | 28861 | 24 | |||
109951 | 204371 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 535 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.80262 | 2089422.42802 | 37.7167821947225 | -122.464489731828 | (37.7167821947225, -122.464489731828) | 9 | 8 | 6 | 64 | 24 | |||
110748 | 205872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 134 Monticello St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991705.27348 | 2089452.68215 | 37.7167625796168 | -122.470639376025 | (37.7167625796168, -122.470639376025) | 9 | 8 | 6 | 64 | 24 | |||
113365 | 204372 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993517.68116 | 2089452.91347 | 37.7168678533586 | -122.464374843447 | (37.7168678533586, -122.464374843447) | 9 | 8 | 6 | 64 | 24 | |||
91457 | 204373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 543 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.88652 | 2089481.01504 | 37.7169430654519 | -122.46449369334 | (37.7169430654519, -122.46449369334) | 9 | 8 | 6 | 64 | 24 | |||
49085 | 204374 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 546 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993518.36116 | 2089503.4985 | 37.7170067869068 | -122.46437616365 | (37.7170067869068, -122.46437616365) | 9 | 8 | 6 | 64 | 24 | |||
144907 | 204375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Head St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993517.97256 | 2089521.38757 | 37.7170558835987 | -122.464378804934 | (37.7170558835987, -122.464378804934) | 9 | 8 | 6 | 64 | 24 | |||
74579 | 204361 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 251 Ralston St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992186.2665 | 2089542.38653 | 37.7170366884615 | -122.468983359893 | (37.7170366884615, -122.468983359893) | 9 | 8 | 6 | 64 | 24 | |||
125991 | 66267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.7183287129789 | -122.394793038594 | (37.7183287129789, -122.394793038594) | 10 | 3 | 8 | 58 | 1 | ||
24776 | 188249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013627.87026 | 2089584.47389 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | 10 | 3 | 8 | 58 | 1 | |||
98115 | 204376 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 567 Head St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993486.95229 | 2089627.04139 | 37.7173441954665 | -122.464493693328 | (37.7173441954665, -122.464493693328) | 9 | 8 | 6 | 64 | 24 | |||
9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
19661 | 175653 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | 1 | 8 | 4 | 64 | 14 | ||||
147022 | 175598 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 655 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001566.02083 | 2089685.89458 | 37.7179682107427 | -122.436572379709 | (37.7179682107427, -122.436572379709) | 9 | 7 | 6 | 28861 | 5 | |||
189118 | 175652 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988848.34422 | 2089725.76423 | 37.7173467747095 | -122.480534235175 | (37.7173467747095, -122.480534235175) | 1 | 8 | 4 | 64 | 14 | ||||
104076 | 175633 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1108 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011834.59323 | 2089743.09488 | 37.7187034559781 | -122.401082217992 | (37.7187034559781, -122.401082217992) | 10 | 7 | 8 | 309 | 39 | |||
13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
143096 | 188255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013785.15628 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | 10 | 3 | 8 | 58 | 1 | ||||
28748 | 188256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013789.26124 | 2089763.61893 | 37.7188686596462 | -122.394327104323 | (37.7188686596462, -122.394327104323) | 10 | 3 | 8 | 58 | 1 | ||||
100463 | 188253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013773.56946 | 2089775.5723 | 37.7189006089484 | -122.394382181502 | (37.7189006089484, -122.394382181502) | 10 | 3 | 8 | 58 | 1 | ||||
62000 | 188252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013770.43233 | 2089778.01595 | 37.7189071443355 | -122.394393196412 | (37.7189071443355, -122.394393196412) | 10 | 3 | 8 | 58 | 1 | ||||
185550 | 188250 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6013748.16101 | 2089779.78907 | 37.7189107748964 | -122.394470304261 | (37.7189107748964, -122.394470304261) | 10 | 3 | 8 | 58 | 1 | ||||
47417 | 188251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013763.34518 | 2089782.1261 | 37.7189180360183 | -122.394417981716 | (37.7189180360183, -122.394417981716) | 10 | 3 | 8 | 58 | 1 | ||||
47074 | 31181 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34879 | 5992668.86925851 | 2089822.40668247 | 37.7178334279778 | -122.467335598289 | (37.7178334279778, -122.467335598289) | 9 | 8 | 6 | 64 | 24 | ||
123681 | 19343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992618.01059 | 2089830.67404 | 37.7178531919595 | -122.467511993496 | (37.7178531919595, -122.467511993496) | 9 | 8 | 6 | 64 | 24 | |||
190132 | 19346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.7179388802504 | -122.46781582944 | (37.7179388802504, -122.46781582944) | 9 | 8 | 6 | 64 | 24 | |||
31511 | 31182 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34880 | 5992624.59921054 | 2089874.97031305 | 37.7179751991794 | -122.467492439169 | (37.7179751991794, -122.467492439169) | 9 | 8 | 6 | 64 | 24 | ||
44453 | 204362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992231.07965 | 2089876.61874 | 37.7179569979942 | -122.468852772034 | (37.7179569979942, -122.468852772034) | 9 | 8 | 6 | 64 | 24 | |||
49240 | 204363 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5992230.03339 | 2089899.44154 | 37.7180196034048 | -122.468858048362 | (37.7180196034048, -122.468858048362) | 9 | 8 | 6 | 64 | 24 | |||
51819 | 175629 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 44 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6009095.75789 | 2089908.29383 | 37.7190038897951 | -122.410560964431 | (37.7190038897951, -122.410560964431) | 9 | 3 | 8 | 309 | 18 | |||
31886 | 175628 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 43 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6009091.54392 | 2089913.69924 | 37.7190184956734 | -122.410575912047 | (37.7190184956734, -122.410575912047) | 9 | 3 | 8 | 309 | 18 | |||
54057 | 175627 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 42 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009089.91396 | 2089921.07864 | 37.7190386665864 | -122.410582067034 | (37.7190386665864, -122.410582067034) | 9 | 3 | 8 | 309 | 18 | |||
102812 | 175626 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 41 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6009096.33692 | 2089936.65243 | 37.7190817890677 | -122.410560964424 | (37.7190817890677, -122.410560964424) | 9 | 3 | 8 | 309 | 18 | |||
36494 | 38922 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | |||
46339 | 54188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | ||
50128 | 175624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009382.81472 | 2090013.8898 | 37.7193099237036 | -122.409576165411 | (37.7193099237036, -122.409576165411) | 9 | 3 | 8 | 309 | 18 | |||
10012 | 175625 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 22 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.7193210519043 | -122.409599906627 | (37.7193210519043, -122.409599906627) | 9 | 3 | 8 | 309 | 18 | |||
57577 | 205845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994459.49219 | 2090019.51391 | 37.7184778466456 | -122.46116053335 | (37.7184778466456, -122.46116053335) | 9 | 8 | 6 | 28861 | 24 | |||
88370 | 175623 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 20 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6009402.84406 | 2090023.10643 | 37.719336352976 | -122.409507581334 | (37.719336352976, -122.409507581334) | 9 | 3 | 8 | 309 | 18 | |||
187185 | 175622 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6009430.20513 | 2090028.38757 | 37.7193523869705 | -122.40941337645 | (37.7193523869705, -122.40941337645) | 9 | 3 | 8 | 309 | 18 | |||
51992 | 175621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6009441.92296 | 2090030.92164 | 37.7193600015446 | -122.409373050849 | (37.7193600015446, -122.409373050849) | 9 | 3 | 8 | 309 | 18 | |||
191169 | 175620 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009477.4678 | 2090042.25002 | 37.7193930983987 | -122.409250984045 | (37.7193930983987, -122.409250984045) | 9 | 3 | 8 | 309 | 18 | |||
173304 | 205844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 19 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994418.11304 | 2090057.91201 | 37.7185808972689 | -122.461306344913 | (37.7185808972689, -122.461306344913) | 9 | 8 | 6 | 28861 | 24 | |||
83368 | 205866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994049.93117 | 2090081.62351 | 37.7186248066558 | -122.462580708559 | (37.7186248066558, -122.462580708559) | 9 | 8 | 6 | 28861 | 24 | |||
184187 | 205843 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994419.00692 | 2090084.06137 | 37.7186527486105 | -122.461305149717 | (37.7186527486105, -122.461305149717) | 9 | 8 | 6 | 28861 | 24 | |||
153406 | 205867 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994049.56571 | 2090091.22883 | 37.7186511595157 | -122.462582668169 | (37.7186511595157, -122.462582668169) | 9 | 8 | 6 | 28861 | 24 | |||
194233 | 205842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994419.52632 | 2090108.84131 | 37.7187208182988 | -122.461305149719 | (37.7187208182988, -122.461305149719) | 9 | 8 | 6 | 28861 | 24 | |||
79692 | 205841 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994419.49218 | 2090156.70217 | 37.7188522308197 | -122.461308735327 | (37.7188522308197, -122.461308735327) | 9 | 8 | 6 | 28861 | 24 | |||
193570 | 205840 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 39 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994420.75333 | 2090183.87687 | 37.7189269186341 | -122.461306344918 | (37.7189269186341, -122.461306344918) | 9 | 8 | 6 | 28861 | 24 | |||
99282 | 205839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 43 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994420.71855 | 2090215.21053 | 37.7190129513734 | -122.461308735321 | (37.7190129513734, -122.461308735321) | 9 | 8 | 6 | 28861 | 24 | |||
36269 | 47348 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45274 | 5994469.1469604 | 2090229.4816179 | 37.7190549234375 | -122.461142372223 | (37.7190549234375, -122.461142372223) | 9 | 8 | 6 | 28861 | 24 | ||
99156 | 175601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 638 Madrid St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6002183.73763 | 2090239.52156 | 37.7195234308436 | -122.434476767784 | (37.7195234308436, -122.434476767784) | 9 | 7 | 6 | 28861 | 5 | |||
117752 | 205838 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994420.67655 | 2090246.19978 | 37.7190980380284 | -122.461311125734 | (37.7190980380284, -122.461311125734) | 9 | 8 | 6 | 28861 | 24 | |||
98405 | 205846 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5994462.98595 | 2090252.19932 | 37.7191169462637 | -122.461165314123 | (37.7191169462637, -122.461165314123) | 9 | 8 | 6 | 28861 | 24 | |||
21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
60805 | 175600 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 626 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002200.33228 | 2090264.59279 | 37.7195932128426 | -122.434421197784 | (37.7195932128426, -122.434421197784) | 9 | 7 | 6 | 28861 | 5 | |||
188122 | 205837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994421.47665 | 2090267.87506 | 37.7191575992129 | -122.461309930536 | (37.7191575992129, -122.461309930536) | 9 | 8 | 6 | 28861 | 24 | |||
165584 | 175648 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | 1 | 8 | 4 | 64 | 14 | |||
31782 | 205865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 565 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994014.3343 | 2090276.58042 | 37.7191580614818 | -122.462717886617 | (37.7191580614818, -122.462717886617) | 9 | 8 | 6 | 64 | 24 | |||
75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
183079 | 31866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35308 | 5994462.19495 | 2090280.44973 | 37.7191944696164 | -122.461170094943 | (37.7191944696164, -122.461170094943) | 9 | 8 | 6 | 28861 | 24 | ||
172655 | 175651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008 | (37.7189698369625, -122.47492674008) | 1 | 8 | 4 | 64 | 14 |
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) );