trees
2,180 rows where qSpecies_id = 57 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
2778 | 227271 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001729.31648 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
4136 | 247842 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 74 Nevada St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6009022.44109 | 2098193.50191 | 37.7417491904794 | -122.411399399688 | (37.7417491904794, -122.411399399688) | 10 | 7 | 7 | 28859 | 2 | |||
4286 | 227210 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Powhattan Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6007555 | 2098218 | 37.7417340415028 | -122.416475073326 | (37.7417340415028, -122.416475073326) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
4467 | 207950 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992685.27644 | 2100498.70583 | 37.7471488342478 | -122.468055053599 | (37.7471488342478, -122.468055053599) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
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 | |||
5567 | 6767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017316.52552 | 2096883.88974 | 37.7386149694956 | -122.382629809543 | (37.7386149694956, -122.382629809543) | 10 | 3 | 8 | 58 | 1 | ||
5650 | 101145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | 10 | 3 | 8 | 28856 | 29 | |||
6003 | 227468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 43 Uranus Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999310.34636 | 2105508.81384 | 37.7612857352771 | -122.445506381621 | (37.7612857352771, -122.445506381621) | 15 | 5 | 5 | 28862 | 3 | |||
6081 | 227347 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006705.44249 | 2097738.30194 | 37.7403690845706 | -122.419378544583 | (37.7403690845706, -122.419378544583) | 2 | 7 | 7 | 28859 | 2 | |||
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6482 | 120477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) | 11 | 6 | 2 | 55 | 26 | |||
6534 | 140294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 180 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998301.012 | 2110133.2386 | 37.7739255579875 | -122.449330419507 | (37.7739255579875, -122.449330419507) | 15 | 5 | 11 | 29492 | 16 | |||
7581 | 9343 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6000760.2622834 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | 2 | 7 | 5 | 63 | 7 | |||
7612 | 15318 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | 8 | 2 | 9 | 28853 | 19 | |||
7750 | 248443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997578.9268 | 2108015.8037 | 37.768070296065 | -122.451675447809 | (37.768070296065, -122.451675447809) | 15 | 5 | 11 | 29492 | 9 | |||
7768 | 227479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 245 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003729.95896 | 2109287.50824 | 37.7719124339341 | -122.430490439197 | (37.7719124339341, -122.430490439197) | 15 | 9 | 11 | 29492 | 10 | |||
7801 | 227380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006886.48628 | 2101479.33864 | 37.7506513240136 | -122.419017843602 | (37.7506513240136, -122.419017843602) | 2 | 4 | 7 | 28859 | 19 | |||
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
8136 | 208000 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999487.48138 | 2094942.52217 | 37.7322833591869 | -122.444134470345 | (37.7322833591869, -122.444134470345) | 9 | 7 | 4 | 63 | 40 | |||
8371 | 12302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.427583190964 | (37.7790930089412, -122.427583190964) | 7 | 9 | 11 | 29490 | 41 | |||
8694 | 227398 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 230 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003842.72624 | 2095288.78693 | 37.7334816230755 | -122.429102075713 | (37.7334816230755, -122.429102075713) | 2 | 7 | 5 | 28861 | 25 | |||
9052 | 227499 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3068 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002862.42767 | 2095876.1703 | 37.7350389026183 | -122.432533184459 | (37.7350389026183, -122.432533184459) | 2 | 7 | 5 | 63 | 7 | |||
9687 | 121554 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 779292 | 6001441 | 2103840 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | 2 | 4 | 5 | 28862 | 3 | ||
9735 | 10183 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1113 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X2 | 6005790.6047359 | 2102492.1542693 | 37.7533705104285 | -122.422879471267 | (37.7533705104285, -122.422879471267) | 2 | 4 | 5 | 28859 | 19 | |||
9817 | 217691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 130 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5992774.4941 | 2097679.5875 | 37.7394134029673 | -122.467541571416 | (37.7394134029673, -122.467541571416) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
10026 | 207816 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5997465.81636 | 2094312.11288 | 37.7304368648498 | -122.451078348996 | (37.7304368648498, -122.451078348996) | 9 | 7 | 4 | 28861 | 40 | |||
10183 | 227374 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006788.4113 | 2101535.34281 | 37.7507995754546 | -122.419360968246 | (37.7507995754546, -122.419360968246) | 2 | 4 | 7 | 28859 | 19 | |||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10932 | 185624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.7461296959342 | -122.494501805094 | (37.7461296959342, -122.494501805094) | 1 | 8 | 3 | 29491 | 35 | |||
11229 | 244526 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 535 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998923.9253 | 2108820.3562 | 37.7703563290142 | -122.447081166685 | (37.7703563290142, -122.447081166685) | 15 | 5 | 11 | 29492 | 9 | |||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
11598 | 227356 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.416314851151 | (37.7360994137559, -122.416314851151) | 2 | 7 | 7 | 28859 | 2 | |||
11655 | 140565 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1135 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003754.9228 | 2111761.6819 | 37.7787073194129 | -122.4305806639 | (37.7787073194129, -122.4305806639) | 15 | 9 | 11 | 29492 | 41 | |||
12145 | 207895 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2405 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991680.9977 | 2099010.21605 | 37.7430037753042 | -122.471419295088 | (37.7430037753042, -122.471419295088) | 1 | 8 | 4 | 29491 | 40 | |||
12497 | 11955 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1469 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6015772.6789286 | 2096311.6012512 | 37.7369581722856 | -122.387927819023 | (37.7369581722856, -122.387927819023) | 10 | 3 | 8 | 58 | 1 | |||
12642 | 129578 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2434 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000794.17611 | 2116746.49388 | 37.7922261557494 | -122.441180751388 | (37.7922261557494, -122.441180751388) | 13 | 6 | 1 | 29490 | 27 | |||
12662 | 217630 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 342 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5992097.4803 | 2096991.2524 | 37.7374842980463 | -122.469832264132 | (37.7374842980463, -122.469832264132) | 1 | 8 | 4 | 59 | 40 | |||
12787 | 227445 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002267.36989 | 2104146.30011 | 37.7577129707038 | -122.435181842588 | (37.7577129707038, -122.435181842588) | 2 | 4 | 5 | 28862 | 3 | |||
12926 | 141575 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1478 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000744.6746 | 2110704.0393 | 37.7756323088735 | -122.440918362809 | (37.7756323088735, -122.440918362809) | 15 | 5 | 11 | 29492 | 10 | |||
13051 | 55532 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | 11 | 8 | 11 | 56 | 12 | |||
13055 | 227379 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006865.43202 | 2101476.67266 | 37.7506428182181 | -122.419090462054 | (37.7506428182181, -122.419090462054) | 2 | 4 | 7 | 28859 | 19 | |||
13359 | 32006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1516 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 12 | 6x7 | Permit Number 35401 | 5993964.99651 | 2112129.18726 | 37.779156921599 | -122.464474250231 | (37.779156921599, -122.464474250231) | 11 | 6 | 2 | 54 | 11 | |
13564 | 227320 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4354 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000901.51564 | 2102318.03914 | 37.7526153534244 | -122.439774441961 | (37.7526153534244, -122.439774441961) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||||
13631 | 207826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5999382.74348 | 2093797.47195 | 37.7291333434223 | -122.444414310576 | (37.7291333434223, -122.444414310576) | 9 | 7 | 4 | 28861 | 40 | |||
14133 | 226668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008865.94709 | 2106940.47139 | 37.7657576213427 | -122.412558680646 | (37.7657576213427, -122.412558680646) | 8 | 4 | 7 | 28853 | 19 | |||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
14552 | 226669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008867.05744 | 2106924.30834 | 37.7657133036545 | -122.412553697512 | (37.7657133036545, -122.412553697512) | 8 | 4 | 7 | 28853 | 19 | |||
14909 | 227253 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6006109.76084 | 2096378.48743 | 37.7366017696511 | -122.421341637808 | (37.7366017696511, -122.421341637808) | 2 | 7 | 7 | 28859 | 2 | |||
14950 | 177116 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 280 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004076.34637 | 2091739.89789 | 37.7237503874544 | -122.428041571781 | (37.7237503874544, -122.428041571781) | 9 | 7 | 6 | 28861 | 5 | |||
14969 | 191498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.7327671503753 | -122.384640862701 | (37.7327671503753, -122.384640862701) | 10 | 3 | 8 | 58 | 1 | |||
14971 | 26336 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997739.39873 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | 9 | 8 | 6 | 28861 | 24 | |||
14994 | 207379 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1251 Funston Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5992036.47883 | 2106848.63378 | 37.7645465861817 | -122.470760979659 | (37.7645465861817, -122.470760979659) | 11 | 8 | 11 | 56 | 12 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
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 | |||
15507 | 207853 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992483.11623 | 2089580.88214 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||||
15651 | 227373 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3400 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006229.03188 | 2102615.79175 | 37.7537347189024 | -122.421372075386 | (37.7537347189024, -122.421372075386) | 2 | 4 | 5 | 28859 | 19 | |||
15687 | 129561 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3299 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000845.88514 | 2119539.08728 | 37.7998968278242 | -122.441202290165 | (37.7998968278242, -122.441202290165) | 13 | 9 | 1 | 57 | 17 | |||
15724 | 227357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007581.53732 | 2096160.90491 | 37.736087204549 | -122.416237655152 | (37.736087204549, -122.416237655152) | 2 | 7 | 7 | 28859 | 2 | |||
15786 | 129665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.8060936540688 | -122.411922953492 | (37.8060936540688, -122.411922953492) | 3 | 1 | 10 | 308 | 23 | |||
16019 | 226708 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1098 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005707.60508 | 2102663.54756 | 37.7538364331257 | -122.423178683847 | (37.7538364331257, -122.423178683847) | 2 | 4 | 5 | 28859 | 19 | |||
16144 | 227418 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001168.68328 | 2104120.67938 | 37.7575801713913 | -122.438979708367 | (37.7575801713913, -122.438979708367) | 2 | 4 | 5 | 28862 | 3 | |||
16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
16518 | 26521 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 7.5x7 | 6009000.88013 | 2101922.62199 | 37.7519873190611 | -122.411737385595 | (37.7519873190611, -122.411737385595) | 2 | 4 | 7 | 28859 | 19 | |||
16666 | 227467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 43 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999304.11308 | 2105493.67356 | 37.7612438079824 | -122.445526851088 | (37.7612438079824, -122.445526851088) | 15 | 5 | 5 | 28862 | 3 | |||
16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
17473 | 201860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010161.8818 | 2110817.0652 | 37.7764744978974 | -122.408349755778 | (37.7764744978974, -122.408349755778) | 8 | 2 | 9 | 28853 | 34 | |||
17665 | 227296 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4217 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002414.71515 | 2100605.94142 | 37.7480003546327 | -122.43441914105 | (37.7480003546327, -122.43441914105) | 2 | 4 | 5 | 63 | 22 | |||
17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
18458 | 191458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6014482.2077 | 2115927.08829 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | 12 | 2 | 9 | 28855 | 6 | |||
18654 | 227381 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3440 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006906.73127 | 2101480.47267 | 37.7506555778088 | -122.418947915021 | (37.7506555778088, -122.418947915021) | 2 | 4 | 7 | 28859 | 19 | |||
18765 | 227461 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999855.35997 | 2105564.48757 | 37.7614697005791 | -122.443625415403 | (37.7614697005791, -122.443625415403) | 15 | 5 | 5 | 28862 | 3 | |||
18778 | 1705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017900.5576644 | 2093604.0676713 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | 10 | 3 | 8 | 58 | 1 | |||
18794 | 177112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.7228528478523 | -122.445587543638 | (37.7228528478523, -122.445587543638) | 9 | 7 | 6 | 28861 | 25 | |||
19061 | 129655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009755.16442 | 2121852.22782 | 37.8067515980625 | -122.410536140452 | (37.8067515980625, -122.410536140452) | 3 | 1 | 10 | 308 | 23 | |||
19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
19216 | 227376 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006793.51754 | 2101495.5657 | 37.7506906441663 | -122.419340488895 | (37.7506906441663, -122.419340488895) | 2 | 4 | 7 | 28859 | 19 |
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) );