trees
2,180 rows where qSpecies_id = 57 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179979 | 207944 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992687.64397 | 2100499.32584 | 37.7471506733621 | -122.468046912034 | (37.7471506733621, -122.468046912034) | 1 | 8 | 4 | 29491 | 40 | |||
183831 | 102192 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
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 | |||
191537 | 207380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1251 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5992036.83974 | 2106822.46143 | 37.7644747447354 | -122.470757824839 | (37.7644747447354, -122.470757824839) | 11 | 8 | 11 | 56 | 12 | |||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
20725 | 12209 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
29008 | 191456 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | 12 | 2 | 9 | 28855 | 6 | |||
30959 | 129658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
35027 | 96011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009766.64536 | 2116419.41202 | 37.7918350666884 | -122.410112610112 | (37.7918350666884, -122.410112610112) | 5 | 1 | 10 | 28857 | 21 |
39322 | 177139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008876.27782 | 2093394.29976 | 37.7285634196519 | -122.411565787757 | (37.7285634196519, -122.411565787757) | 9 | 3 | 7 | 309 | 28 | |||
40600 | 17748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.423120547185 | (37.7892164261498, -122.423120547185) | 13 | 9 | 1 | 28858 | 41 | |||
41881 | 245073 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 12 Lyon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000398.2075 | 2109021.498 | 37.7709927363786 | -122.441996078881 | (37.7709927363786, -122.441996078881) | 15 | 5 | 11 | 29492 | 9 | |||
42013 | 122135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.474541227661 | (37.78686657212, -122.474541227661) | 11 | 6 | 1 | 54 | 33 | ||||
46242 | 129668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.8063709591182 | -122.411985864676 | (37.8063709591182, -122.411985864676) | 3 | 1 | 10 | 308 | 23 | |||
46904 | 208006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 551 Joost Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998446.5912 | 2094951.62857 | 37.7322489268386 | -122.447733705547 | (37.7322489268386, -122.447733705547) | 9 | 7 | 4 | 59 | 40 | |||
47726 | 129679 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6012036.63622 | 2116793.11614 | 37.79298814054 | -122.402284681698 | (37.79298814054, -122.402284681698) | 4 | 1 | 10 | 28854 | 6 | |||
52882 | 102190 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
54535 | 114470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | 3 | 1 | 10 | 308 | 23 | |||
56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
62566 | 113965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011669.50654 | 2107216.87583 | 37.7666735080099 | -122.402881155253 | (37.7666735080099, -122.402881155253) | 8 | 2 | 8 | 28853 | 20 | |||
63003 | 120478 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2201 Lake St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5988614.91495 | 2114641.72629 | 37.7857457871807 | -122.483166366817 | (37.7857457871807, -122.483166366817) | 11 | 6 | 2 | 55 | 26 | |||
63813 | 227269 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001725.03317 | 2099972.93353 | 37.7462230919389 | -122.436758722841 | (37.7462230919389, -122.436758722841) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||||
82534 | 249628 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2450 Golden Gate Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 7ft | 5997613.51975 | 2111318.82879 | 37.7771415320813 | -122.45179410234 | (37.7771415320813, -122.45179410234) | 15 | 6 | 2 | 54 | 16 | |||
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 | ||||
91360 | 110190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
92429 | 227195 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 434 Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008560.63223 | 2096613.27489 | 37.7373843201389 | -122.412884488848 | (37.7373843201389, -122.412884488848) | 10 | 7 | 7 | 28859 | 2 | |||
96553 | 207830 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999312.24137 | 2093797.37115 | 37.7291290437632 | -122.444658034037 | (37.7291290437632, -122.444658034037) | 9 | 7 | 4 | 28861 | 40 | |||
99343 | 24542 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500X Cortland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/29/1999 12:00:00 AM | 18 | 3X3 | 6007686.22354 | 2097194.49045 | 37.7389310892969 | -122.415948881937 | (37.7389310892969, -122.415948881937) | 2 | 7 | 7 | 28859 | 2 | ||
101846 | 191493 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008691.52097 | 2110325.94896 | 37.7750435612459 | -122.413401429955 | (37.7750435612459, -122.413401429955) | 8 | 2 | 9 | 28853 | 34 | |||
105996 | 227341 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008425.7912 | 2096773.31918 | 37.737816197044 | -122.41336201354 | (37.737816197044, -122.41336201354) | 10 | 7 | 7 | 28859 | 2 | |||
112331 | 103606 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||||
114846 | 207822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998191.35411 | 2093811.83744 | 37.7291047386702 | -122.448534057207 | (37.7291047386702, -122.448534057207) | 9 | 7 | 4 | 28861 | 40 | |||
119360 | 227226 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3181 22nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007165.55053 | 2103203.73405 | 37.7554018308516 | -122.418175054731 | (37.7554018308516, -122.418175054731) | 2 | 4 | 7 | 28859 | 19 | |||
120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
121584 | 37255 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
127210 | 207923 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993572.45221 | 2095069.9309 | 37.7322939729878 | -122.464593161969 | (37.7322939729878, -122.464593161969) | 9 | 8 | 4 | 59 | 40 | |||
129359 | 183931 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1595 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988739.7309 | 2101009.2638 | 37.7483220449634 | -122.481735662973 | (37.7483220449634, -122.481735662973) | 1 | 8 | 3 | 29491 | 35 | |||
134643 | 207865 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 374 Irving St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995644.83212 | 2106690.30276 | 37.7643198590097 | -122.458269282206 | (37.7643198590097, -122.458269282206) | 15 | 5 | 11 | 56 | 12 | |||
137555 | 227310 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Beacon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002320.65439 | 2098300.93501 | 37.7416660076813 | -122.434579607974 | (37.7416660076813, -122.434579607974) | 2 | 7 | 5 | 63 | 7 | |||
139598 | 177127 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006940.52586 | 2093410.55841 | 37.728499289894 | -122.418258956995 | (37.728499289894, -122.418258956995) | 9 | 3 | 7 | 309 | 5 | |||
144134 | 207901 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991520.05038 | 2097071.77928 | 37.7376720105541 | -122.471834558838 | (37.7376720105541, -122.471834558838) | 1 | 8 | 4 | 29491 | 40 | |||
145161 | 177055 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998959.63131 | 2090185.20091 | 37.7191907338521 | -122.445617380444 | (37.7191907338521, -122.445617380444) | 9 | 7 | 6 | 28861 | 25 | |||
149805 | 207961 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Woodside Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995740.66413 | 2100249.86529 | 37.7466415563731 | -122.457471834475 | (37.7466415563731, -122.457471834475) | 1 | 5 | 4 | 59 | 40 | |||
152683 | 98649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.7991623281478 | -122.434737597267 | (37.7991623281478, -122.434737597267) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||||
163900 | 207945 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992693.35222 | 2100498.87072 | 37.7471497533695 | -122.468027140435 | (37.7471497533695, -122.468027140435) | 1 | 8 | 4 | 29491 | 40 | |||
180952 | 227256 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006035.34272 | 2096387.96537 | 37.7366235979955 | -122.421599606546 | (37.7366235979955, -122.421599606546) | 2 | 7 | 7 | 28859 | 2 | |||
182521 | 250113 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006068.77978 | 2115421.44634 | 37.7888869424356 | -122.422836287668 | (37.7888869424356, -122.422836287668) | 13 | 9 | 1 | 28858 | 41 | |||
188077 | 207997 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999481.71143 | 2094946.11387 | 37.7322928919832 | -122.444154676308 | (37.7322928919832, -122.444154676308) | 9 | 7 | 4 | 63 | 40 | |||
188173 | 129627 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2137 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006391.72079 | 2118062.38927 | 37.7961565285655 | -122.421906628814 | (37.7961565285655, -122.421906628814) | 13 | 9 | 10 | 28858 | 32 | |||
192501 | 14791 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
165770 | 186910 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2700 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985181.9251 | 2096700.884 | 37.7362848611965 | -122.49372085207 | (37.7362848611965, -122.49372085207) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
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 | |||
26550 | 122134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991116.74625 | 2115003.65081 | 37.7868848032576 | -122.4745372499 | (37.7868848032576, -122.4745372499) | 11 | 6 | 1 | 54 | 33 | ||||
27129 | 227227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3181 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007147.96039 | 2103204.37763 | 37.7554026078658 | -122.418235932549 | (37.7554026078658, -122.418235932549) | 2 | 4 | 7 | 28859 | 19 | |||
27217 | 191492 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008677.6339 | 2110340.84375 | 37.7750836791036 | -122.413450522147 | (37.7750836791036, -122.413450522147) | 8 | 2 | 9 | 28853 | 34 | |||
27752 | 227423 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4611 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000635.58472 | 2104641.67508 | 37.7589803519927 | -122.44086074744 | (37.7589803519927, -122.44086074744) | 2 | 4 | 5 | 28862 | 38 | |||
31614 | 129649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009816.83805 | 2121725.36163 | 37.8064067125673 | -122.410313742595 | (37.8064067125673, -122.410313742595) | 3 | 1 | 10 | 308 | 23 | |||
36519 | 177044 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 87 Seneca Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6000253.62595 | 2089858.96532 | 37.7183687570946 | -122.44112115244 | (37.7183687570946, -122.44112115244) | 9 | 7 | 6 | 28861 | 25 | |||
39407 | 227268 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 739 27th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | 2 | 7 | 5 | 63 | 22 | |||
39700 | 20264 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
41145 | 207832 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999123.91286 | 2093462.37431 | 37.7281984720769 | -122.44528502248 | (37.7281984720769, -122.44528502248) | 9 | 7 | 4 | 28861 | 40 | ||||
42379 | 227255 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 191 Park St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006055.55534 | 2096385.40989 | 37.7366177209345 | -122.421529541274 | (37.7366177209345, -122.421529541274) | 2 | 7 | 7 | 28859 | 2 | |||
43401 | 226689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6011390.67503 | 2102355.0144 | 37.7533083467103 | -122.403503500497 | (37.7533083467103, -122.403503500497) | 10 | 4 | 8 | 28859 | 19 | |||
43666 | 207960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Woodside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995744.16421 | 2100249.04136 | 37.7466394951101 | -122.457459672038 | (37.7466394951101, -122.457459672038) | 1 | 5 | 4 | 59 | 40 | |||
56613 | 227286 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 691 29th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6002107.89107 | 2098826.53454 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | 2 | 7 | 5 | 63 | 7 | ||||
57591 | 207856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993273.29613 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | 9 | 8 | 6 | 64 | 24 | |||
62844 | 227444 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002287.98273 | 2104149.35711 | 37.7577225349845 | -122.435110773646 | (37.7577225349845, -122.435110773646) | 2 | 4 | 5 | 28862 | 3 | |||
63173 | 207829 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999329.28012 | 2093797.53913 | 37.7291304772829 | -122.444599141963 | (37.7291304772829, -122.444599141963) | 9 | 7 | 4 | 28861 | 40 | |||
63465 | 96010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.20911 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) | 5 | 1 | 10 | 28857 | 21 |
66513 | 226752 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004776.27473 | 2109101.09065 | 37.7714597925537 | -122.426857876903 | (37.7714597925537, -122.426857876903) | 7 | 9 | 5 | 28852 | 10 | |||
66971 | 227288 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 689 29th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002143.45873 | 2098830.19502 | 37.7431091713442 | -122.435230137975 | (37.7431091713442, -122.435230137975) | 2 | 7 | 5 | 63 | 7 | ||||
69299 | 121398 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4098x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002425 | 2104765 | 37.7594207214866 | -122.434680934086 | (37.7594207214866, -122.434680934086) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | |||
78075 | 98679 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 5 | 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 | ||||
80462 | 207900 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Wawona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991529.51733 | 2097072.34326 | 37.737674106866 | -122.471801868461 | (37.737674106866, -122.471801868461) | 1 | 8 | 4 | 29491 | 40 | |||
80623 | 177063 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.445449436536 | (37.7201371416945, -122.445449436536) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||||
86637 | 129678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) | 4 | 1 | 10 | 28854 | 6 | |||
86724 | 37256 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
89650 | 20269 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
90277 | 129602 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1699 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005553.17918 | 2118195.8648 | 37.7964756925582 | -122.424817655109 | (37.7964756925582, -122.424817655109) | 13 | 9 | 1 | 28858 | 27 | |||
90373 | 227174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 146 Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997925.34727 | 2106207.55247 | 37.7631251303526 | -122.450346856639 | (37.7631251303526, -122.450346856639) | 15 | 5 | 11 | 29492 | 9 | |||
92358 | 129597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005573.05547 | 2117336.02058 | 37.7941159002879 | -122.424687680612 | (37.7941159002879, -122.424687680612) | 13 | 9 | 1 | 28858 | 27 | |||
93000 | 207946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 09th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992698.06615 | 2100499.10664 | 37.7471506733717 | -122.468010857342 | (37.7471506733717, -122.468010857342) | 1 | 8 | 4 | 29491 | 40 | |||
93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
97248 | 227342 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3915 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008421.86118 | 2096747.11308 | 37.7377440201602 | -122.413373748818 | (37.7377440201602, -122.413373748818) | 10 | 7 | 7 | 28859 | 2 | |||
103551 | 102191 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
108751 | 113964 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 11 | 3x3 | 6011665.76024 | 2107233.19616 | 37.7667181107677 | -122.402895261101 | (37.7667181107677, -122.402895261101) | 8 | 2 | 8 | 28853 | 20 | ||
109724 | 9317 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | ||
110109 | 116049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.7615544688802 | -122.403342277248 | (37.7615544688802, -122.403342277248) | 10 | 3 | 8 | 28856 | 29 | ||
110752 | 140577 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1225 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003319.3616 | 2111705.1064 | 37.7785272927548 | -122.432083397248 | (37.7785272927548, -122.432083397248) | 15 | 9 | 11 | 29492 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );