trees
3,965 rows where qSpecies_id = 70 sorted by Neighborhoods (old) 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) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117377 | 125317 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013195.02023 | 2118529.35833 | 37.7978200432104 | -122.398398464716 | (37.7978200432104, -122.398398464716) | 3 | 1 | 10 | 28860 | 6 | |||
140128 | 125303 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
141202 | 188715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6014787.2921 | 2115709.23152 | 37.7901652027998 | -122.392691330139 | (37.7901652027998, -122.392691330139) | 6 | 2 | 9 | 28855 | 6 | |||
144170 | 125315 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013199.69177 | 2118499.63281 | 37.7977386842466 | -122.398380212981 | (37.7977386842466, -122.398380212981) | 3 | 1 | 10 | 28860 | 6 | |||
147671 | 116003 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 945 FRONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | 3x3 | 6012663 | 2119386 | 37.8001425245044 | -122.400299613665 | (37.8001425245044, -122.400299613665) | 3 | 1 | 10 | 28860 | 6 | ||
148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
149553 | 125322 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013162.23077 | 2118766.61136 | 37.7984696568162 | -122.398528583126 | (37.7984696568162, -122.398528583126) | 3 | 1 | 10 | 28860 | 6 | |||
149631 | 125314 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013200.68159 | 2118482.22968 | 37.7976909545355 | -122.398375566176 | (37.7976909545355, -122.398375566176) | 3 | 1 | 10 | 28860 | 6 | |||
154289 | 188713 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6014826.65865 | 2115671.24883 | 37.7900630973959 | -122.392552465835 | (37.7900630973959, -122.392552465835) | 6 | 2 | 9 | 28855 | 6 | |||
157823 | 188714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014809.60929 | 2115691.05583 | 37.7901165359975 | -122.392612841812 | (37.7901165359975, -122.392612841812) | 6 | 2 | 9 | 28855 | 6 | |||
158882 | 125320 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013174.3915 | 2118673.3183 | 37.7982141737976 | -122.398479953184 | (37.7982141737976, -122.398479953184) | 3 | 1 | 10 | 28860 | 6 | |||
166021 | 125305 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
168226 | 188709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6014993.3762 | 2115925.05204 | 37.7907692396516 | -122.391993387893 | (37.7907692396516, -122.391993387893) | 6 | 2 | 9 | 28855 | 6 | |||
175152 | 188711 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015034.4377 | 2115884.60313 | 37.7906604558597 | -122.391848486415 | (37.7906604558597, -122.391848486415) | 6 | 2 | 9 | 28855 | 6 | |||
183556 | 125312 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013208.18659 | 2118424.48929 | 37.7975328312411 | -122.398345543235 | (37.7975328312411, -122.398345543235) | 3 | 1 | 10 | 28860 | 6 | |||
190117 | 188716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6014770.59198 | 2115729.03116 | 37.7902186405175 | -122.39275049743 | (37.7902186405175, -122.39275049743) | 6 | 2 | 9 | 28855 | 6 | |||
190153 | 125318 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013183.07782 | 2118614.70431 | 37.7980537176562 | -122.398445780741 | (37.7980537176562, -122.398445780741) | 3 | 1 | 10 | 28860 | 6 | |||
191472 | 34879 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | 6 | 2 | 9 | 28855 | 6 | ||||
2155 | 174995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 83 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000678.32688 | 2088039.79794 | 37.71339791366 | -122.439522805332 | (37.71339791366, -122.439522805332) | 9 | 7 | 6 | 28861 | 5 | |||
5478 | 175059 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005473.36477 | 2092951.58695 | 37.7271563601569 | -122.423298402505 | (37.7271563601569, -122.423298402505) | 9 | 7 | 6 | 28861 | 5 | |||
8673 | 175076 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1262 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6001389.55659 | 2087620.87899 | 37.7122881079857 | -122.437034577295 | (37.7122881079857, -122.437034577295) | 9 | 7 | 6 | 28861 | 5 | |||
25537 | 175005 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6000792.5891 | 2087495.45523 | 37.7119097722015 | -122.439088886968 | (37.7119097722015, -122.439088886968) | 9 | 7 | 6 | 28861 | 5 | |||
26139 | 253819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100x Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001057 | 2086858 | 37.7101745029318 | -122.43812937572 | (37.7101745029318, -122.43812937572) | 9 | 7 | 6 | 28861 | 5 | |||||
31114 | 175073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1109 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001851.58682 | 2087075.00114 | 37.7108154987183 | -122.435398641242 | (37.7108154987183, -122.435398641242) | 9 | 7 | 6 | 28861 | 5 | |||
31651 | 174975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002092.43802 | 2088621.22126 | 37.7150747544838 | -122.434676698769 | (37.7150747544838, -122.434676698769) | 9 | 7 | 6 | 28861 | 5 | |||
35837 | 114606 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 CURTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000494 | 2088444 | 37.7144972695987 | -122.440188869703 | (37.7144972695987, -122.440188869703) | 9 | 7 | 6 | 28861 | 5 | ||||
43462 | 24278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 16 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000808.42529 | 2086790.57674 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | 9 | 7 | 6 | 28861 | 5 | |||
44801 | 25393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | 9 | 7 | 6 | 28861 | 5 | |||
48392 | 175001 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6000856.01918 | 2088342.93848 | 37.714240381459 | -122.438930350851 | (37.714240381459, -122.438930350851) | 9 | 7 | 6 | 28861 | 5 | |||
50479 | 120538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002576.6751 | 2087720.05109 | 37.7126278178947 | -122.43293862582 | (37.7126278178947, -122.43293862582) | 9 | 7 | 6 | 28861 | 5 | |||
50973 | 43163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.26694 | 37.7260364164322 | -122.422690190993 | (37.7260364164322, -122.422690190993) | 9 | 7 | 7 | 309 | 5 | |
58812 | 175007 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6000780.85798 | 2087537.73014 | 37.712025182185 | -122.439132460907 | (37.712025182185, -122.439132460907) | 9 | 7 | 6 | 28861 | 5 | |||
66743 | 175008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 162 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999477.70218 | 2087171.23206 | 37.7109446224578 | -122.443610214149 | (37.7109446224578, -122.443610214149) | 9 | 7 | 6 | 28861 | 5 | |||
70395 | 174981 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002909.51396 | 2089790.51984 | 37.7183317437001 | -122.431935981587 | (37.7183317437001, -122.431935981587) | 9 | 7 | 6 | 28861 | 5 | |||
74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
74761 | 174977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001002.85904 | 2088768.34496 | 37.7154168062239 | -122.4384532767 | (37.7154168062239, -122.4384532767) | 9 | 7 | 6 | 28861 | 5 | |||
79875 | 174991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 42 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000531.41546 | 2088375.4753 | 37.7143112462302 | -122.440054636526 | (37.7143112462302, -122.440054636526) | 9 | 7 | 6 | 28861 | 5 | |||
82296 | 175002 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000849.25835 | 2088363.04115 | 37.7142951942344 | -122.438955158647 | (37.7142951942344, -122.438955158647) | 9 | 7 | 6 | 28861 | 5 | |||
82457 | 255992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6000562.83378 | 2088278.17036 | 37.7140458572152 | -122.439939070053 | (37.7140458572152, -122.439939070053) | 9 | 7 | 6 | 28861 | 5 | ||||
83209 | 174990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 123 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000722.13053 | 2088562.69277 | 37.7148361589252 | -122.439408863925 | (37.7148361589252, -122.439408863925) | 9 | 7 | 6 | 28861 | 5 | |||
83311 | 174980 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002900.06306 | 2089775.87856 | 37.7182910061937 | -122.431967604438 | (37.7182910061937, -122.431967604438) | 9 | 7 | 6 | 28861 | 5 | |||
85312 | 175074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 6001979.9665 | 2087165.3446 | 37.7110708522134 | -122.434961389078 | (37.7110708522134, -122.434961389078) | 9 | 7 | 6 | 28861 | 5 | |||
91816 | 175060 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.7292089332358 | -122.422256493849 | (37.7292089332358, -122.422256493849) | 9 | 7 | 6 | 28861 | 5 | |||
95711 | 174987 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6001163.67681 | 2088517.01471 | 37.7147358557539 | -122.437879429197 | (37.7147358557539, -122.437879429197) | 9 | 7 | 6 | 28861 | 5 | |||
98363 | 174988 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6001118.27335 | 2088513.95986 | 37.7147248858297 | -122.438036143261 | (37.7147248858297, -122.438036143261) | 9 | 7 | 6 | 28861 | 5 | |||
100203 | 174978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001016.58593 | 2088794.32712 | 37.7154889282344 | -122.438407690968 | (37.7154889282344, -122.438407690968) | 9 | 7 | 6 | 28861 | 5 | |||
101389 | 174994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 86 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000642.03466 | 2088027.29642 | 37.7133615216919 | -122.439647347957 | (37.7133615216919, -122.439647347957) | 9 | 7 | 6 | 28861 | 5 | |||
105200 | 113348 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | 9 | 7 | 6 | 28861 | 5 | |||
105857 | 175004 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000799.83685 | 2087474.06608 | 37.7118514547512 | -122.4390623048 | (37.7118514547512, -122.4390623048) | 9 | 7 | 6 | 28861 | 5 | |||
106195 | 174983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1005 Madrid St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6001103.82585 | 2088413.52914 | 37.7144483038197 | -122.438078889846 | (37.7144483038197, -122.438078889846) | 9 | 7 | 6 | 28861 | 5 | |||
111250 | 174972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002023.67142 | 2088654.27361 | 37.7151616047126 | -122.434916747615 | (37.7151616047126, -122.434916747615) | 9 | 7 | 6 | 28861 | 5 | |||
112372 | 175000 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000913.68292 | 2088416.04072 | 37.7144443845714 | -122.438736278079 | (37.7144443845714, -122.438736278079) | 9 | 7 | 6 | 28861 | 5 | |||
113841 | 174982 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 323 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002277.67573 | 2091830.36717 | 37.7238968690373 | -122.434265730182 | (37.7238968690373, -122.434265730182) | 9 | 7 | 6 | 28861 | 5 | |||
115600 | 24277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 15 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000814.16949 | 2086790.45771 | 37.7099752333455 | -122.43896380744 | (37.7099752333455, -122.43896380744) | 9 | 7 | 6 | 28861 | 5 | |||
118067 | 102444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.7157989956067 | -122.436645469419 | (37.7157989956067, -122.436645469419) | 9 | 7 | 6 | 28861 | 5 | |||
118802 | 175077 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 19 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6002777.56398 | 2087080.30562 | 37.7108826088193 | -122.432198632175 | (37.7108826088193, -122.432198632175) | 9 | 7 | 6 | 28861 | 5 | |||
120304 | 174992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000562.83378 | 2088278.17036 | 37.7140458572152 | -122.439939070053 | (37.7140458572152, -122.439939070053) | 9 | 7 | 6 | 28861 | 5 | |||
124396 | 175075 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1082 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 6001955.35702 | 2087155.69226 | 37.7110429516559 | -122.435045755382 | (37.7110429516559, -122.435045755382) | 9 | 7 | 6 | 28861 | 5 | |||
133198 | 175071 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 327 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6003750.62272 | 2091634.49721 | 37.7234425468108 | -122.429160031623 | (37.7234425468108, -122.429160031623) | 9 | 7 | 6 | 28861 | 5 | |||
143345 | 174973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002045.00305 | 2088644.45077 | 37.7151358445192 | -122.434842314338 | (37.7151358445192, -122.434842314338) | 9 | 7 | 6 | 28861 | 5 | |||
148042 | 174976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 842 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001033.7824 | 2088915.45345 | 37.7158224921953 | -122.438356925152 | (37.7158224921953, -122.438356925152) | 9 | 7 | 6 | 28861 | 5 | |||
148996 | 174989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Madrid St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6001106.19823 | 2088490.69664 | 37.7146603234954 | -122.438076214354 | (37.7146603234954, -122.438076214354) | 9 | 7 | 6 | 28861 | 5 | |||
150714 | 175006 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000786.30661 | 2087518.08241 | 37.7119715439251 | -122.439112221648 | (37.7119715439251, -122.439112221648) | 9 | 7 | 6 | 28861 | 5 | |||
157385 | 253179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201x Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001862 | 2086566 | 37.709418484595 | -122.435326265286 | (37.709418484595, -122.435326265286) | 9 | 7 | 6 | 28861 | 5 | ||||
158033 | 115359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 345 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 5x6 | 6001770.67381 | 2087944.68785 | 37.7131988712114 | -122.43574047716 | (37.7131988712114, -122.43574047716) | 9 | 7 | 6 | 28861 | 5 | |||
160762 | 98352 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001689 | 2086535 | 37.709323539126 | -122.435921964243 | (37.709323539126, -122.435921964243) | 9 | 7 | 6 | 28861 | 5 | ||||
163657 | 174996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6000640.56256 | 2088159.86327 | 37.7137254368584 | -122.439661934055 | (37.7137254368584, -122.439661934055) | 9 | 7 | 6 | 28861 | 5 | |||
165204 | 174974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002064.20446 | 2088635.744 | 37.7151130278188 | -122.434775323822 | (37.7151130278188, -122.434775323822) | 9 | 7 | 6 | 28861 | 5 | |||
168070 | 175072 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6001924.03435 | 2087085.77592 | 37.710849198115 | -122.435149016425 | (37.710849198115, -122.435149016425) | 9 | 7 | 6 | 28861 | 5 | |||
168584 | 174985 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001137.79283 | 2088470.92046 | 37.7146078192813 | -122.437965595033 | (37.7146078192813, -122.437965595033) | 9 | 7 | 6 | 28861 | 5 | |||
168779 | 174998 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 47 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6000602.5075 | 2088281.55039 | 37.7140573963984 | -122.439802185116 | (37.7140573963984, -122.439802185116) | 9 | 7 | 6 | 28861 | 5 | |||
172734 | 115358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 353 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778572 | 6001795.91538 | 2087927.53278 | 37.7131532009313 | -122.435652007258 | (37.7131532009313, -122.435652007258) | 9 | 7 | 6 | 28861 | 5 | |
173929 | 174979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6001031.1498 | 2088817.30686 | 37.7155528538591 | -122.438358997196 | (37.7155528538591, -122.438358997196) | 9 | 7 | 6 | 28861 | 5 | |||
182792 | 174984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1005 Madrid St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 6001116.49451 | 2088434.79524 | 37.7145074162652 | -122.438036624391 | (37.7145074162652, -122.438036624391) | 9 | 7 | 6 | 28861 | 5 | |||
183071 | 174999 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000885.12559 | 2088432.14846 | 37.7144869881473 | -122.438836136976 | (37.7144869881473, -122.438836136976) | 9 | 7 | 6 | 28861 | 5 | |||
183968 | 174986 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001150.38066 | 2088493.13611 | 37.7146695343409 | -122.437923676751 | (37.7146695343409, -122.437923676751) | 9 | 7 | 6 | 28861 | 5 | |||
184543 | 175003 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6000843.24005 | 2088383.12844 | 37.7143500070223 | -122.438977398908 | (37.7143500070223, -122.438977398908) | 9 | 7 | 6 | 28861 | 5 | |||
185599 | 174993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 82 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000637.15099 | 2088042.26781 | 37.7134023518192 | -122.439665300239 | (37.7134023518192, -122.439665300239) | 9 | 7 | 6 | 28861 | 5 | |||
1494 | 21556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1409 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005783.75363 | 2114822.50195 | 37.7872263038018 | -122.423779835692 | (37.7872263038018, -122.423779835692) | 13 | 9 | 1 | 28858 | 41 | |||
2487 | 6047 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1230X Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001382.35259 | 2112608.72867 | 37.7808984019389 | -122.438849005281 | (37.7808984019389, -122.438849005281) | 15 | 5 | 11 | 29490 | 41 | |||
6759 | 111228 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
7614 | 6251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | 7 | 9 | 11 | 29490 | 41 | |||
8752 | 7916 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.7857108313539 | -122.423161466763 | (37.7857108313539, -122.423161466763) | 13 | 9 | 1 | 28858 | 41 | |||
9096 | 249565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | |||
17786 | 258887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | ||||
19803 | 7872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006017.92474 | 2113680.12204 | 37.7841028269903 | -122.422888431641 | (37.7841028269903, -122.422888431641) | 7 | 9 | 11 | 28858 | 41 | |||
21595 | 26448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1817 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001669.86946 | 2112366.99146 | 37.7802510063553 | -122.437837026039 | (37.7802510063553, -122.437837026039) | 15 | 5 | 11 | 29490 | 41 | |||
22272 | 5913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004490.90647 | 2112892.55275 | 37.7818540774754 | -122.428115221825 | (37.7818540774754, -122.428115221825) | 7 | 9 | 11 | 29490 | 41 | |||
23390 | 22618 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
23932 | 141128 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1730 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6002572.3595 | 2113034.093 | 37.782133976563 | -122.434762619209 | (37.782133976563, -122.434762619209) | 15 | 5 | 11 | 29490 | 41 | |||
24943 | 98739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 20 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
28598 | 249574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Franklin St | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6006046.96797 | 2113547.66581 | 37.7837407734727 | -122.422778535918 | (37.7837407734727, -122.422778535918) | 7 | 9 | 11 | 28858 | 41 | |||
29454 | 141126 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1710 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6002662.7181 | 2113050.3373 | 37.7821837088509 | -122.434451181435 | (37.7821837088509, -122.434451181435) | 15 | 5 | 11 | 29490 | 41 | |||
29904 | 98737 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 24 | 4X4 | 6002360 | 2112467 | 37.7805648236525 | -122.435456706153 | (37.7805648236525, -122.435456706153) | 15 | 5 | 11 | 29490 | 41 | ||
33190 | 7922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1295X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x6 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | 13 | 9 | 1 | 28858 | 41 | |||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
36156 | 22614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.7813650138202 | -122.424863625752 | (37.7813650138202, -122.424863625752) | 7 | 9 | 11 | 28852 | 41 | |||
38846 | 17708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1195X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002295.810192 | 2112602.928985 | 37.7809344045898 | -122.435688496636 | (37.7809344045898, -122.435688496636) | 15 | 5 | 11 | 29490 | 41 |
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) );