trees
2,180 rows where qSpecies_id = 57 sorted by PlantType descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType ▲ | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
5540 | 64827 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 274 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | 2 | 7 | 5 | 63 | 22 | ||
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 | |||
6151 | 69083 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.7618277896301 | -122.470363712817 | (37.7618277896301, -122.470363712817) | 1 | 8 | 4 | 56 | 12 |
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6285 | 72175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000606.57902 | 2119937.60106 | 37.8009774064533 | -122.442058997842 | (37.8009774064533, -122.442058997842) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
7016 | 61846 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | 2 | 4 | 7 | 28859 | 19 | ||
7160 | 62593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.23688 | 37.7750775975018 | -122.497347157504 | (37.7750775975018, -122.497347157504) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
7648 | 62594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.89863 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
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 | |||
7855 | 60037 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 84 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | 6 | 2 | 9 | 28856 | 6 | |
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 | |||
8214 | 73718 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001058.66667 | 2093583.83186 | 37.7286422173636 | -122.438605218052 | (37.7286422173636, -122.438605218052) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
8666 | 72016 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
9059 | 77640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 0 | 6006980.92428 | 2093193.11147 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | 9 | 3 | 7 | 309 | 5 | ||
9097 | 74222 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012358.62681 | 2102848.31202 | 37.7547168532055 | -122.400190745215 | (37.7547168532055, -122.400190745215) | 10 | 3 | 8 | 28856 | 29 | |||
9252 | 73860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.413635639483 | (37.7977968533, -122.413635639483) | 3 | 1 | 10 | 308 | 21 | |||
9311 | 71535 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007520.46607 | 2118819.96047 | 37.7983002218264 | -122.418054666102 | (37.7983002218264, -122.418054666102) | 5 | 1 | 10 | 28858 | 32 | |||
9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 | ||
9420 | 62591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.7745737920548 | -122.497317337939 | (37.7745737920548, -122.497317337939) | 11 | 6 | 2 | 55 | 26 | |
9666 | 60024 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 181 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | 6 | 2 | 9 | 28856 | 6 | |
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 | |||
9894 | 60029 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.393315638611 | (37.7818164104522, -122.393315638611) | 6 | 2 | 9 | 28856 | 6 | |
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 | |||
10089 | 83062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||||||||||||||
10259 | 66383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 6 | Permit Number 29509 | 5997500.2628 | 2113257.2822 | 37.782457530461 | -122.452325802952 | (37.782457530461, -122.452325802952) | 15 | 6 | 1 | 54 | 31 | |
10546 | 77641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006964.98892 | 2093186.85252 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | 9 | 3 | 7 | 309 | 5 | ||
10830 | 67725 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.7630825579563 | -122.470451434039 | (37.7630825579563, -122.470451434039) | 1 | 8 | 11 | 56 | 12 | ||
10883 | 62592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
11770 | 61941 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 178 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 21999 | 6005366.58200406 | 2100230.03647017 | 37.7471353221182 | -122.424184964624 | (37.7471353221182, -122.424184964624) | 2 | 7 | 5 | 28859 | 22 | ||
11890 | 72130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
12299 | 70030 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | 15 | 6 | 1 | 54 | 31 | |||
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 | |||
12880 | 71814 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5995915.83222 | 2114038.69637 | 37.7845121880339 | -122.457863769922 | (37.7845121880339, -122.457863769922) | 11 | 6 | 1 | 54 | 31 |
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) );