trees
614 rows where qSpecies_id = 29 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
2771 | 240393 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Hill St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6006109.51353 | 2103440.58038 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | 2 | 4 | 5 | 28859 | 19 | |||
3428 | 37647 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | 11 | 6 | 2 | 54 | 11 | ||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
6569 | 82802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | 11 | 6 | 2 | 55 | 26 | ||
7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
11342 | 141053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.7818900483272 | -122.45414629098 | (37.7818900483272, -122.45414629098) | 11 | 6 | 1 | 54 | 31 | ||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
14387 | 181350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.7452110255779 | -122.48221942867 | (37.7452110255779, -122.48221942867) | 1 | 8 | 3 | 29491 | 35 | |||
17790 | 181349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987333.026 | 2099936.24 | 37.7452939056167 | -122.486521176816 | (37.7452939056167, -122.486521176816) | 1 | 8 | 3 | 29491 | 35 | |||
20030 | 81327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | 13 | 9 | 1 | 57 | 17 | |
20270 | 41769 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
20373 | 122290 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990062.61204 | 2111318.02169 | 37.7767039596239 | -122.477914733898 | (37.7767039596239, -122.477914733898) | 11 | 6 | 2 | 55 | 26 | |||
20573 | 122277 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | 11 | 6 | 2 | 55 | 26 | |||
20719 | 32859 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
20853 | 33056 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
21743 | 9330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.5022559 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | 2 | 7 | 5 | 63 | 7 | ||
21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
22308 | 33551 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.7400478987016 | -122.418202822848 | (37.7400478987016, -122.418202822848) | 2 | 7 | 7 | 28859 | 2 | |||
23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
23194 | 136319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010537.58998 | 2122003.14861 | 37.8072098224406 | -122.407839040359 | (37.8072098224406, -122.407839040359) | 3 | 1 | 10 | 308 | 23 | |||
23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
23748 | 124092 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991890.07496 | 2111196.52278 | 37.7764762519633 | -122.471584203691 | (37.7764762519633, -122.471584203691) | 11 | 6 | 2 | 54 | 11 | ||||
24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
24228 | 48907 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
24465 | 48904 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
26389 | 87804 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841 | 2117073 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | 13 | 9 | 1 | 28858 | 27 | ||
26602 | 48668 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3362 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2002 12:00:00 AM | 2 | Permit Number 45951 | 5998735.75428 | 2115612.17598 | 37.788994153303 | -122.448221183082 | (37.788994153303, -122.448221183082) | 13 | 6 | 1 | 54 | 31 | ||
26771 | 83492 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2040 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50186 | 5981220.21812771 | 2101179.004699 | 37.7483479647664 | -122.50775007916 | (37.7483479647664, -122.50775007916) | 1 | 8 | 3 | 29491 | 35 | ||
27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
28524 | 34910 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | 9 | 8 | 6 | 28861 | 24 | |||
29514 | 214024 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000768.15588 | 2094464.11739 | 37.7310427480136 | -122.439672611702 | (37.7310427480136, -122.439672611702) | 9 | 7 | 4 | 63 | 40 | |||
30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
30225 | 33058 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | ||
30874 | 18608 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | 9 | 8 | 6 | 64 | 24 | ||
31150 | 214014 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992138.11746 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | 1 | 8 | 4 | 56 | 12 | |||
31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
31605 | 118182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985646.49411 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | 11 | 6 | 2 | 55 | 26 | |||
31613 | 33057 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
35401 | 26068 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | 9 | 8 | 6 | 28861 | 24 | ||
36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
36465 | 214012 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992097.04207 | 2105377.93896 | 37.7605119495939 | -122.47044439309 | (37.7605119495939, -122.47044439309) | 1 | 8 | 4 | 56 | 12 | |||
39109 | 186232 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.7545428359635 | -122.495522842112 | (37.7545428359635, -122.495522842112) | 1 | 8 | 3 | 56 | 35 | |||
39191 | 63013 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | 2 | 7 | 7 | 28859 | 2 | |
39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
40164 | 136317 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.7981207171523 | -122.413165857925 | (37.7981207171523, -122.413165857925) | 3 | 1 | 10 | 308 | 21 | |||
40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
40902 | 38028 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.469656660064 | (37.7415161934278, -122.469656660064) | 1 | 8 | 4 | 29491 | 40 | |||
40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
41119 | 184434 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3816 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981590.8846 | 2100821.8038 | 37.7473890220179 | -122.506441860059 | (37.7473890220179, -122.506441860059) | 1 | 8 | 3 | 29491 | 35 | |||
41839 | 122286 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | 11 | 6 | 2 | 55 | 26 | |||
41944 | 140855 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.456081435491 | (37.7838757026194, -122.456081435491) | 11 | 6 | 1 | 54 | 31 | |||
42377 | 140854 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.7838767259243 | -122.456131829019 | (37.7838767259243, -122.456131829019) | 11 | 6 | 1 | 54 | 31 | |||
42698 | 41761 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
43394 | 92109 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | 11 | 6 | 2 | 55 | 26 | |
44625 | 186236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.7545219168817 | -122.495498186629 | (37.7545219168817, -122.495498186629) | 1 | 8 | 3 | 56 | 35 | |||
45022 | 240381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 98 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008070.80857 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | 8 | 4 | 7 | 28853 | 19 | |||
45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
46083 | 89314 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2005 12:00:00 AM | 3x3 | Permit Number 48328 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
46975 | 82884 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
48198 | 18596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.466428817805 | (37.7141961040887, -122.466428817805) | 9 | 8 | 6 | 64 | 24 | ||
48948 | 48905 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
49381 | 97195 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | ||
49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
50181 | 89199 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51816 | 5999889 | 2119639 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | 13 | 9 | 1 | 57 | 17 | ||
51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
51945 | 214035 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999120.59989 | 2093807.09624 | 37.7291448088802 | -122.445321250796 | (37.7291448088802, -122.445321250796) | 9 | 7 | 4 | 28861 | 40 | ||||
52077 | 122289 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990067.41245 | 2111319.50308 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | 11 | 6 | 2 | 55 | 26 | |||
52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
53151 | 122280 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990124.51868 | 2111321.36168 | 37.7767167231412 | -122.477700827061 | (37.7767167231412, -122.477700827061) | 11 | 6 | 2 | 55 | 26 | |||
53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 |
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) );