trees
2,180 rows where qSpecies_id = 57 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
15273 | 249329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 814 Post St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008232.68347 | 2114867.71891 | 37.7874883986038 | -122.415310240102 | (37.7874883986038, -122.415310240102) | 13 | 1 | 10 | 28858 | 21 | |||
21862 | 191445 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 19th St | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6013335.75988 | 2105192.04749 | 37.7612066758622 | -122.396975847857 | (37.7612066758622, -122.396975847857) | 10 | 3 | 8 | 28856 | 29 | |||
36498 | 191448 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | 10 | 3 | 8 | 58 | 1 | |||
47088 | 246495 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 359 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004220.12982 | 2099827.66275 | 37.7459656978564 | -122.428120633885 | (37.7459656978564, -122.428120633885) | 2 | 7 | 5 | 63 | 22 | |||
52506 | 207862 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Vernon St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5992461.4298 | 2088225.86047 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | 9 | 8 | 6 | 64 | 24 | |||
56899 | 226665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004711.01966 | 2109215.80754 | 37.7717710874854 | -122.427091769887 | (37.7717710874854, -122.427091769887) | 7 | 9 | 11 | 28852 | 10 | |||
69727 | 226663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004754.99125 | 2108900.44461 | 37.7709076637003 | -122.426917205171 | (37.7709076637003, -122.426917205171) | 7 | 9 | 11 | 28852 | 10 | |||
92866 | 226666 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6004707.88321 | 2109244.50494 | 37.7718497062225 | -122.427104663459 | (37.7718497062225, -122.427104663459) | 7 | 9 | 11 | 28852 | 10 | |||
100778 | 191508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 55 Sherman St | 25 | : | Tree | Private 2 | 3 | Width 10ft | 6010631.50278 | 2111081.40715 | 37.7772266061547 | -122.406743828871 | (37.7772266061547, -122.406743828871) | 14 | 2 | 9 | 28853 | 34 | |||
101328 | 191443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 19th St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6013161.12259 | 2105230.38347 | 37.7613022153415 | -122.397582536801 | (37.7613022153415, -122.397582536801) | 10 | 3 | 8 | 28856 | 29 | |||
110484 | 207859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | 9 | 8 | 6 | 64 | 24 | |||
119782 | 207860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992206.43527 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | 9 | 8 | 6 | 64 | 24 | |||
121804 | 191449 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1224 Fairfax Ave | 4 | : | Tree | Private 2 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | 10 | 3 | 8 | 58 | 1 | |||
125739 | 226667 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6004704.09472 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | 7 | 9 | 11 | 28852 | 10 | |||
128918 | 191444 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Connecticut St | 1 | : | Tree | Private 2 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | 14 | 3 | 8 | 28856 | 29 | |||
131753 | 191447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300 Phelps St | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | 10 | 3 | 8 | 58 | 1 | |||
144219 | 226664 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6004714.27593 | 2109192.94036 | 37.7717084838914 | -122.427078877212 | (37.7717084838914, -122.427078877212) | 7 | 9 | 11 | 28852 | 10 | |||
151518 | 207864 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2545 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991142.22279 | 2094819.87718 | 37.7314669887904 | -122.472976710428 | (37.7314669887904, -122.472976710428) | 1 | 8 | 4 | 64 | 40 | |||
162954 | 207858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 143 Garfield St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993571.00568 | 2090460.55199 | 37.7196376600192 | -122.464263641377 | (37.7196376600192, -122.464263641377) | 9 | 8 | 6 | 64 | 24 | |||
181485 | 226662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004759.39323 | 2108882.79631 | 37.7708594546408 | -122.426900721499 | (37.7708594546408, -122.426900721499) | 7 | 9 | 11 | 28852 | 10 | |||
184435 | 191450 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Fairfax Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.7392132974473 | -122.383283724566 | (37.7392132974473, -122.383283724566) | 10 | 3 | 8 | 58 | 1 | |||
141228 | 191435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1310 Indiana St | 1 | : Yard | Tree | Private 2 | 1 | 6014946.60084 | 2102566.45751 | 37.7540869042097 | -122.391221052827 | (37.7540869042097, -122.391221052827) | 10 | 3 | 8 | 28856 | 29 | ||||
51213 | 227504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 16 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002174.41423 | 2096447.25188 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | 2 | 7 | 5 | 63 | 7 | |||
84620 | 227505 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 11 Ohlone Way | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | 2 | 7 | 5 | 63 | 7 | |||
24777 | 121592 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6002342 | 2100313 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | 2 | 4 | 5 | 63 | 22 | ||||
153318 | 114098 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 219x VIDAL DR | 1 | Front Yard : Cutout | Tree | Private 2 | 40 | 5987664 | 2090565 | 37.7195822022131 | -122.484689437364 | (37.7195822022131, -122.484689437364) | 1 | 8 | 4 | 64 | 14 | ||||
13575 | 247947 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 9 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6010380.59474 | 2098877.37331 | 37.7437030359631 | -122.406751516274 | (37.7437030359631, -122.406751516274) | 2 | 7 | 7 | 28859 | 2 | ||||
15535 | 247946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Joy St | 2 | Front Yard : Yard | Tree | Private 2 | 39 | 6010368.2533 | 2098885.09245 | 37.7437235405125 | -122.406794734117 | (37.7437235405125, -122.406794734117) | 2 | 7 | 7 | 28859 | 2 | ||||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
48384 | 227291 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 65 Zircon Pl | 4 | Front Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.434490777424 | (37.7428156470274, -122.434490777424) | 2 | 7 | 5 | 63 | 7 | |||
53881 | 254253 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Grove St | 1 | Front Yard : Yard | Tree | Private 2 | 6004708 | 2111182 | 37.777169601607 | -122.427242295103 | (37.777169601607, -122.427242295103) | 7 | 9 | 11 | 28852 | 10 | |||||
57293 | 226687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 22nd St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6011241.49222 | 2103724.78971 | 37.7570611132947 | -122.404115802095 | (37.7570611132947, -122.404115802095) | 10 | 4 | 8 | 28859 | 19 | ||||
58321 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 239x VIDAL DR | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 5987668 | 2090475 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | 1 | 8 | 4 | 64 | 14 | ||||
59010 | 226690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 San Bruno Ave | 0 | Front Yard : Yard | Tree | Private 2 | 0 | 6011227.79267 | 2101285.4147 | 37.7503623610541 | -122.403991519419 | (37.7503623610541, -122.403991519419) | 10 | 4 | 8 | 28859 | 19 | ||||
62436 | 227451 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 Storrie St | 11 | Front Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6000780.7251 | 2105298.91991 | 37.7607932503354 | -122.440405921619 | (37.7607932503354, -122.440405921619) | 15 | 4 | 5 | 28862 | 3 | |||
67290 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
69188 | 191446 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Tulare St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6016252.95003 | 2100312.60959 | 37.7479707183947 | -122.386546192477 | (37.7479707183947, -122.386546192477) | 3 | 8 | 58 | 1 | |||||
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
85676 | 226705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | 6004844.71466 | 2096725.50128 | 37.7374831871032 | -122.425740140092 | (37.7374831871032, -122.425740140092) | 2 | 7 | 5 | 63 | 7 | ||||
138358 | 191438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2209 25th St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | 6012142.94506 | 2101858.42279 | 37.7519868046503 | -122.400867092959 | (37.7519868046503, -122.400867092959) | 10 | 3 | 8 | 28856 | 29 | ||||
142665 | 226706 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Eugenia Ave | 31 | Front Yard : Yard | Tree | Private 2 | 3 | Width 10ft | 6006654.02073 | 2098088.92739 | 37.7413289273824 | -122.419581211314 | (37.7413289273824, -122.419581211314) | 2 | 7 | 7 | 28859 | 2 | |||
176372 | 247955 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 6 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 6010457.43679 | 2098876.11874 | 37.7437038903352 | -122.40648572526 | (37.7437038903352, -122.40648572526) | 2 | 7 | 7 | 28859 | 2 | ||||
74029 | 177088 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300x Winding Way | 5 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6001504.62112 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | 9 | 7 | 6 | 28861 | 5 | |||
55598 | 207809 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200x Terrace Dr | 30 | Median : Yard | Tree | DPW 1 | 16 | 5993795.90954 | 2096545.04749 | 37.7363571576556 | -122.463927661846 | (37.7363571576556, -122.463927661846) | 1 | 8 | 4 | 59 | 40 | ||||
59284 | 191502 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 29 | Median : Yard | Tree | DPW 1 | 7 | 6016510.31046 | 2096089.32701 | 37.7363886887837 | -122.385361989469 | (37.7363886887837, -122.385361989469) | 10 | 3 | 8 | 58 | 1 | ||||
87418 | 256350 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 29 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
127544 | 191437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300x De Haro St | 31 | Median : Yard | Tree | DPW 1 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | 10 | 3 | 8 | 28856 | 29 | ||||
143348 | 191501 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 27 | 6016915.88272 | 2095866.14342 | 37.7357983009387 | -122.383944206463 | (37.7357983009387, -122.383944206463) | 10 | 3 | 8 | 58 | 1 | ||||
149901 | 256348 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
155921 | 247023 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550x Valley St | 1 | Median : Yard | Tree | DPW 1 | 7 | 6002381.07182 | 2099185.81683 | 37.7440991162756 | -122.434433957386 | (37.7440991162756, -122.434433957386) | 2 | 7 | 5 | 63 | 22 | ||||
193853 | 256349 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3000X Sunset Blvd | 28 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
30344 | 247848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Chapman St | 3 | Side Yard : Yard | Tree | Private 2 | 37 | 6009193.51112 | 2098205.92163 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | 10 | 7 | 7 | 28859 | 2 | ||||
31380 | 227459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Corbin Pl | 7 | Side Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | 15 | 5 | 5 | 28862 | 3 | |||
34855 | 227503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 31 Poppy Ln | 6 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6002189.282 | 2096805.2578 | 37.7375517667019 | -122.434926909075 | (37.7375517667019, -122.434926909075) | 2 | 7 | 5 | 63 | 7 | |||
77590 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 99X Cleveland St | 3 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
78483 | 248064 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 18 Rutledge St | 6 | Side Yard : Yard | Tree | Private 2 | 24 | 6010656.53215 | 2099389.02438 | 37.7451233541731 | -122.405833420001 | (37.7451233541731, -122.405833420001) | 2 | 7 | 7 | 28859 | 2 | ||||
89687 | 248057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 17 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) | 2 | 7 | 7 | 28859 | 2 | ||||
101427 | 227460 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Corbin Pl | 9 | Side Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | 15 | 5 | 5 | 28862 | 3 | |||
149494 | 207987 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 714 Detroit St | 19 | Side Yard : Yard | Tree | Private 2 | 8 | 5999466.17422 | 2095456.65433 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | 9 | 7 | 4 | 63 | 40 | ||||
151712 | 247843 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 151 Chapman St | 1 | Side Yard : Yard | Tree | Private 2 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | 10 | 7 | 7 | 28859 | 2 | ||||
152335 | 207986 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 714 Detroit St | 8 | Side Yard : Yard | Tree | Private 2 | 7 | 5999466.52885 | 2095410.65053 | 37.7335675344178 | -122.444240535497 | (37.7335675344178, -122.444240535497) | 9 | 7 | 4 | 63 | 40 | ||||
162588 | 247877 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 388 Mayflower St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 6009910.50595 | 2098381.82666 | 37.7423160592417 | -122.408342032063 | (37.7423160592417, -122.408342032063) | 10 | 7 | 7 | 28859 | 2 | ||||
168819 | 247878 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 388 Mayflower St | 7 | Side Yard : Yard | Tree | Private 2 | 7 | 6009913.73125 | 2098387.19098 | 37.7423309691095 | -122.408331258187 | (37.7423309691095, -122.408331258187) | 10 | 7 | 7 | 28859 | 2 | ||||
173699 | 247844 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 151 Chapman St | 2 | Side Yard : Yard | Tree | Private 2 | 23 | 6009115.84276 | 2098211.04411 | 37.7418025958075 | -122.41107768521 | (37.7418025958075, -122.41107768521) | 10 | 7 | 7 | 28859 | 2 | ||||
193416 | 129641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 943 Green St | 12 | Side Yard : Yard | Tree | Private 2 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.414066792462 | (37.7987948111981, -122.414066792462) | 5 | 1 | 10 | 308 | 21 | ||||
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
250 | 248390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998825.2199 | 2108039.7272 | 37.7682072798204 | -122.447366392326 | (37.7682072798204, -122.447366392326) | 15 | 5 | 11 | 29492 | 9 | |||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
573 | 227463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 238 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999836.92244 | 2105557.8617 | 37.7614504560077 | -122.443688706966 | (37.7614504560077, -122.443688706966) | 15 | 5 | 5 | 28862 | 3 | |||
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
1173 | 227375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006792.16678 | 2101508.46009 | 37.7507259731465 | -122.419346074576 | (37.7507259731465, -122.419346074576) | 2 | 4 | 7 | 28859 | 19 | |||
1250 | 227382 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008243.43201 | 2102726.48966 | 37.7541520375997 | -122.414413633986 | (37.7541520375997, -122.414413633986) | 2 | 4 | 7 | 28859 | 19 | |||
1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
1456 | 207879 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1677 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5992449.40881 | 2104058.56598 | 37.7569096647699 | -122.469129702993 | (37.7569096647699, -122.469129702993) | 1 | 8 | 4 | 56 | 12 | |||
1632 | 227241 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 957 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005737.27172 | 2103394.53822 | 37.7558452379797 | -122.423128044836 | (37.7558452379797, -122.423128044836) | 2 | 4 | 5 | 28859 | 19 | |||
1783 | 61503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.7846543745532 | -122.479617149177 | (37.7846543745532, -122.479617149177) | 11 | 6 | 2 | 55 | 26 | |
1826 | 62206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22328 | 6001109.87298 | 2093671.7514 | 37.7288865370674 | -122.438434491679 | (37.7288865370674, -122.438434491679) | 9 | 7 | 6 | 28861 | 25 | |
2105 | 227358 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007594.39314 | 2096161.75328 | 37.7360902568635 | -122.416193267317 | (37.7360902568635, -122.416193267317) | 2 | 7 | 7 | 28859 | 2 | |||
2171 | 61848 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | 2 | 4 | 7 | 28859 | 19 | ||
2396 | 61859 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | 8 | Permit Number 21899 | 6010253.66087773 | 2102459.66274806 | 37.75353211276 | -122.407442925811 | (37.75353211276, -122.407442925811) | 2 | 4 | 7 | 28859 | 19 | |
2410 | 207916 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994697.35407 | 2099701.10711 | 37.7450748213407 | -122.461039698642 | (37.7450748213407, -122.461039698642) | 1 | 8 | 4 | 59 | 40 | |||
2419 | 227204 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 11x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6007526 | 2096627 | 37.7373638762388 | -122.416462675749 | (37.7373638762388, -122.416462675749) | 2 | 7 | 7 | 28859 | 2 | |||
2536 | 73723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | 13 | 9 | 1 | 57 | 17 | |||
2636 | 17716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1238 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 6 | 3X3 | 6002311.2541 | 2112835.6256 | 37.7815742079744 | -122.43565172132 | (37.7815742079744, -122.43565172132) | 15 | 5 | 11 | 29490 | 41 | ||
2842 | 227420 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4611 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000592.58463 | 2104640.99159 | 37.7589760262452 | -122.441009412547 | (37.7589760262452, -122.441009412547) | 2 | 4 | 5 | 28862 | 38 | |||
2935 | 246401 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1599 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998515.5772 | 2108578.3087 | 37.7696683888949 | -122.448476202514 | (37.7696683888949, -122.448476202514) | 15 | 5 | 11 | 29492 | 9 | |||
3257 | 62475 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 14 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 14 | Permit Number 22646 | 6001230.17424 | 2093762.35137 | 37.729142145995 | -122.438025089712 | (37.729142145995, -122.438025089712) | 9 | 7 | 6 | 28861 | 25 | |
3425 | 60034 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 108 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.84947 | 37.7815842801353 | -122.394312917534 | (37.7815842801353, -122.394312917534) | 6 | 2 | 9 | 28856 | 6 | |
3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
4055 | 138702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2521 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001130.8799 | 2114520.0235 | 37.7861320179479 | -122.439856047477 | (37.7861320179479, -122.439856047477) | 15 | 6 | 1 | 29490 | 27 | |||
4363 | 227340 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008451 | 2096866 | 37.7380720936745 | -122.413281406339 | (37.7380720936745, -122.413281406339) | 10 | 7 | 7 | 28859 | 2 | |||
4457 | 27392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.8016469274247 | -122.419461214785 | (37.8016469274247, -122.419461214785) | 5 | 1 | 1 | 28858 | 32 | |||
4615 | 207908 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Wawona St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992548.53449 | 2097821.47012 | 37.739789928349 | -122.468333152763 | (37.739789928349, -122.468333152763) | 1 | 8 | 4 | 59 | 40 | |||
4618 | 31345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34956 | 6006088.23081 | 2111255.80978 | 37.7774502243821 | -122.422472877923 | (37.7774502243821, -122.422472877923) | 7 | 9 | 11 | 28852 | 10 | |
4710 | 143042 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | 3 | 1 | 10 | 308 | 23 | |||
4770 | 191477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6014491.1655 | 2112621.09872 | 37.7816694477368 | -122.393499699264 | (37.7816694477368, -122.393499699264) | 6 | 2 | 9 | 28856 | 6 | |||
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
5324 | 177073 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 250 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012250.9341 | 2087164.61689 | 37.7116466881279 | -122.399462161252 | (37.7116466881279, -122.399462161252) | 10 | 3 | 8 | 309 | 1 |
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) );