trees
2,180 rows where qSpecies_id = 57 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
156461 | 61840 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | 10 | 4 | 7 | 28859 | 19 | ||
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 | ||
133401 | 227260 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6001350.1729 | 2100676.35822 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | 2 | 4 | 5 | 28862 | 22 | |||
157730 | 227259 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 6001350.9072 | 2100668.98044 | 37.748113001917 | -122.438102253317 | (37.748113001917, -122.438102253317) | 2 | 4 | 5 | 28862 | 22 | |||
187677 | 141820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004741.7405 | 2112502.8158 | 37.7807981447488 | -122.427219682298 | (37.7807981447488, -122.427219682298) | 7 | 9 | 11 | 29490 | 41 | |||
25375 | 12330 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | 7 | 9 | 11 | 29490 | 41 | ||
61667 | 12329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4X4 | 6004738.43022 | 2112529.1477 | 37.7808702584368 | -122.427233010388 | (37.7808702584368, -122.427233010388) | 7 | 9 | 11 | 29490 | 41 | |||
147051 | 227246 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 104 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000168.90266 | 2100069.23534 | 37.7463989525502 | -122.442146526165 | (37.7463989525502, -122.442146526165) | 2 | 7 | 5 | 63 | 22 | |||
18665 | 60026 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 104 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.09477 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | 6 | 2 | 9 | 28856 | 6 | |
90755 | 61047 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | 9 | 7 | 4 | 28861 | 40 | ||
153054 | 227240 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1041 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6005776.90584 | 2102650.34664 | 37.7538040971062 | -122.422938087332 | (37.7538040971062, -122.422938087332) | 2 | 4 | 5 | 28859 | 19 | |||
105649 | 141818 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004738.0171 | 2112555.418 | 37.7809423668258 | -122.427236311405 | (37.7809423668258, -122.427236311405) | 7 | 9 | 11 | 29490 | 41 | |||
160837 | 141819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004740.795 | 2112530.2338 | 37.7808733743326 | -122.42722490684 | (37.7808733743326, -122.42722490684) | 7 | 9 | 11 | 29490 | 41 | |||
42108 | 12331 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6004735.87767 | 2112555.20778 | 37.7809416686235 | -122.427243697772 | (37.7809416686235, -122.427243697772) | 7 | 9 | 11 | 29490 | 41 | |||
14305 | 73447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007557.7828 | 2115066.68598 | 37.7879967592968 | -122.417659373585 | (37.7879967592968, -122.417659373585) | 13 | 1 | 10 | 28858 | 21 | |||
14609 | 70619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | 13 | 1 | 10 | 28858 | 21 | |||
32961 | 34389 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | 2 | 7 | 5 | 63 | 7 | ||
62499 | 227327 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6003998.12904 | 2097070.3333 | 37.7383821413251 | -122.428691759122 | (37.7383821413251, -122.428691759122) | 2 | 7 | 5 | 63 | 7 | |||
120471 | 61847 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21886 | 6010217.4028677 | 2103099.43948978 | 37.7552867678032 | -122.407613419659 | (37.7552867678032, -122.407613419659) | 2 | 4 | 7 | 28859 | 19 | ||
70071 | 129614 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824897 | (37.7854973571526, -122.42115824897) | 13 | 9 | 9 | 28858 | 36 | |||
194489 | 64389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.7854381817627 | -122.421152111986 | (37.7854381817627, -122.421152111986) | 13 | 9 | 9 | 28858 | 36 | ||
184447 | 61841 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.407434066583 | (37.7552975843096, -122.407434066583) | 10 | 4 | 7 | 28859 | 19 | ||
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 | ||
44037 | 226739 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010223.2273 | 2103077.92399 | 37.7552280170702 | -122.407591760047 | (37.7552280170702, -122.407591760047) | 2 | 4 | 7 | 28859 | 19 | |||
141044 | 207819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 106 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998117.86344 | 2093869.45755 | 37.7292587475919 | -122.448792267857 | (37.7292587475919, -122.448792267857) | 9 | 7 | 4 | 28861 | 40 | |||
48919 | 226713 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010264.70472 | 2103053.83895 | 37.7551642065834 | -122.407446620265 | (37.7551642065834, -122.407446620265) | 10 | 4 | 7 | 28859 | 19 | |||
81077 | 61842 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.4074193619 | (37.7551438802467, -122.4074193619) | 10 | 4 | 7 | 28859 | 19 | ||
85229 | 68478 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810754 | 37.755071582179 | -122.407592832606 | (37.755071582179, -122.407592832606) | 2 | 4 | 7 | 28859 | 19 | ||
136189 | 226740 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010224.3865 | 2103036.61596 | 37.7551146593158 | -122.407584838872 | (37.7551146593158, -122.407584838872) | 2 | 4 | 7 | 28859 | 19 | |||
179184 | 45683 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.415328273299 | (37.79625955578, -122.415328273299) | 5 | 1 | 10 | 28858 | 21 | ||
49050 | 227322 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000618.20547 | 2102486.60155 | 37.7530620547894 | -122.440766265559 | (37.7530620547894, -122.440766265559) | 2 | 4 | 5 | 28862 | 22 | |||
21791 | 141984 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004054.425 | 2111804.9181 | 37.7788429977364 | -122.429547653761 | (37.7788429977364, -122.429547653761) | 7 | 9 | 11 | 29490 | 41 | |||
37518 | 14788 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
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 | ||
66748 | 61850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1078 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21889 | 6010226.10973791 | 2102942.52266102 | 37.7548563965432 | -122.407572245672 | (37.7548563965432, -122.407572245672) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |
53576 | 227212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1085 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007655.00083 | 2103359.6493 | 37.7558574759534 | -122.416493425951 | (37.7558574759534, -122.416493425951) | 2 | 4 | 7 | 28859 | 19 | |||
163166 | 227213 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1085 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007654.8641 | 2103387.34278 | 37.7559335082294 | -122.416495860392 | (37.7559335082294, -122.416495860392) | 2 | 4 | 7 | 28859 | 19 | |||
146447 | 141983 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1087 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003986.8959 | 2111785.937 | 37.7787870565894 | -122.429779909358 | (37.7787870565894, -122.429779909358) | 7 | 9 | 11 | 29490 | 41 | |||
159407 | 61844 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21883 | 6010281.13947097 | 2102889.36180769 | 37.754713508851 | -122.40737818911 | (37.754713508851, -122.40737818911) | 10 | 4 | 7 | 28859 | 19 | ||
167795 | 226712 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010271.79932 | 2102896.97753 | 37.754733897156 | -122.407411026915 | (37.754733897156, -122.407411026915) | 10 | 4 | 7 | 28859 | 19 | |||
69727 | 226663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004754.99125 | 2108900.44461 | 37.7709076637003 | -122.426917205171 | (37.7709076637003, -122.426917205171) | 7 | 9 | 11 | 28852 | 10 | |||
181485 | 226662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004759.39323 | 2108882.79631 | 37.7708594546408 | -122.426900721499 | (37.7708594546408, -122.426900721499) | 7 | 9 | 11 | 28852 | 10 | |||
52021 | 67901 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175 | -122.45122163283 | (37.729148458175, -122.45122163283) | 9 | 7 | 4 | 28861 | 40 | ||
106777 | 207817 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997420.91181 | 2093893.18113 | 37.7292840068365 | -122.451203388929 | (37.7292840068365, -122.451203388929) | 9 | 7 | 4 | 28861 | 40 | |||
149574 | 10179 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1090X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6005708.4809651 | 2102624.2723741 | 37.7537286419918 | -122.423172863278 | (37.7537286419918, -122.423172863278) | 2 | 4 | 5 | 28859 | 19 | |||
100176 | 10181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005777.3462689 | 2102574.3880576 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
68456 | 61845 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21884 | 6010284.24906681 | 2102833.32009511 | 37.7545598048232 | -122.407363484663 | (37.7545598048232, -122.407363484663) | 10 | 4 | 7 | 28859 | 19 | ||
96071 | 226711 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010275.94257 | 2102860.11647 | 37.7546329167906 | -122.407394099856 | (37.7546329167906, -122.407394099856) | 10 | 4 | 7 | 28859 | 19 | |||
84620 | 227505 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 11 Ohlone Way | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
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 | |||
54289 | 191452 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6014395.41652 | 2116019.04089 | 37.7909940953523 | -122.394068897285 | (37.7909940953523, -122.394068897285) | 12 | 2 | 9 | 28855 | 6 | |||
77998 | 191459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6014515.87712 | 2115897.32843 | 37.7906665955326 | -122.393643582697 | (37.7906665955326, -122.393643582697) | 12 | 2 | 9 | 28855 | 6 | |||
79679 | 191457 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014474.34711 | 2115936.1277 | 37.7907708215543 | -122.393789992334 | (37.7907708215543, -122.393789992334) | 12 | 2 | 9 | 28855 | 6 | |||
85538 | 191451 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 3ft | 6014385.34548 | 2116032.04037 | 37.7910292291593 | -122.39410465341 | (37.7910292291593, -122.39410465341) | 12 | 2 | 9 | 28855 | 6 | |||
118745 | 191455 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6014431.23151 | 2115982.96922 | 37.7908970414242 | -122.393942451705 | (37.7908970414242, -122.393942451705) | 12 | 2 | 9 | 28855 | 6 | |||
160299 | 191460 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6014521.60501 | 2115886.59071 | 37.7906374305211 | -122.393623012505 | (37.7906374305211, -122.393623012505) | 12 | 2 | 9 | 28855 | 6 | |||
162526 | 191453 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.7909687560468 | -122.39402291674 | (37.7909687560468, -122.39402291674) | 12 | 2 | 9 | 28855 | 6 | |||
185357 | 191454 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.7909276399352 | -122.393974517007 | (37.7909276399352, -122.393974517007) | 12 | 2 | 9 | 28855 | 6 | |||
190453 | 201856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010248.3954 | 2110901.8137 | 37.7767120417305 | -122.408056457346 | (37.7767120417305, -122.408056457346) | 8 | 2 | 9 | 28853 | 34 | |||
36663 | 142060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004266.4173 | 2112234.0727 | 37.7800333508893 | -122.428844891753 | (37.7800333508893, -122.428844891753) | 7 | 9 | 11 | 29490 | 41 | |||
124714 | 142061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004236.163 | 2112229.3455 | 37.7800186587405 | -122.428949217889 | (37.7800186587405, -122.428949217889) | 7 | 9 | 11 | 29490 | 41 | |||
194071 | 142062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | 7 | 9 | 11 | 29490 | 41 | |
21457 | 73647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.7993439875935 | -122.404021813977 | (37.7993439875935, -122.404021813977) | 3 | 1 | 10 | 308 | 23 | |
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 | ||||
115029 | 61248 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.7994807139026 | -122.417425152198 | (37.7994807139026, -122.417425152198) | 5 | 1 | 1 | 308 | 32 | ||
134832 | 201857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1104 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010239.403 | 2110891.1863 | 37.7766823578859 | -122.408086815194 | (37.7766823578859, -122.408086815194) | 8 | 2 | 9 | 28853 | 34 | |||
104433 | 227169 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1105 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998133.53414 | 2106486.83201 | 37.7639038739782 | -122.449646937655 | (37.7639038739782, -122.449646937655) | 15 | 5 | 11 | 29492 | 9 | |||
155736 | 227170 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1105 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998136.60734 | 2106470.82303 | 37.7638600931786 | -122.449635154751 | (37.7638600931786, -122.449635154751) | 15 | 5 | 11 | 29492 | 9 | |||
86929 | 226723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010287.53935 | 2102671.43851 | 37.7541154981458 | -122.407340694523 | (37.7541154981458, -122.407340694523) | 10 | 4 | 7 | 28859 | 19 | |||
87613 | 61851 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21890 | 6010288.8067389 | 2102753.58958513 | 37.7543411376679 | -122.407342102556 | (37.7543411376679, -122.407342102556) | 10 | 4 | 7 | 28859 | 19 | ||
52385 | 226722 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1111 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010289.0097 | 2102653.41278 | 37.7540660857915 | -122.407334339005 | (37.7540660857915, -122.407334339005) | 10 | 4 | 7 | 28859 | 19 | |||
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 | |||
154201 | 129637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1113 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007650.63926 | 2119186.93082 | 37.7993151562271 | -122.417630249946 | (37.7993151562271, -122.417630249946) | 5 | 1 | 10 | 28858 | 32 | |||
67877 | 201858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010186.2664 | 2110842.1371 | 37.7765447049461 | -122.408267170875 | (37.7765447049461, -122.408267170875) | 8 | 2 | 9 | 28853 | 34 | |||
68254 | 201859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010175.6391 | 2110829.8748 | 37.7765104404434 | -122.408303068844 | (37.7765104404434, -122.408303068844) | 8 | 2 | 9 | 28853 | 34 | |||
107703 | 14796 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1115 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003814.9868 | 2111771.4066 | 37.7787374235047 | -122.430373573251 | (37.7787374235047, -122.430373573251) | 15 | 9 | 11 | 29492 | 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 | |||
66394 | 201861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010150.0088 | 2110807.2194 | 37.7764467987551 | -122.408390133412 | (37.7764467987551, -122.408390133412) | 8 | 2 | 9 | 28853 | 34 | |||
147518 | 227239 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1117 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6005786.23679 | 2102453.87032 | 37.7532651450948 | -122.422891855875 | (37.7532651450948, -122.422891855875) | 2 | 4 | 5 | 28859 | 19 | |||
86744 | 207834 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
32214 | 61853 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.7541263174163 | -122.407320968841 | (37.7541263174163, -122.407320968841) | 10 | 4 | 7 | 28859 | 19 | ||
110433 | 226721 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6010296.19253 | 2102509.90887 | 37.753672457944 | -122.407299383281 | (37.753672457944, -122.407299383281) | 10 | 4 | 7 | 28859 | 19 | |||
78491 | 10185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005788.91126 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | 2 | 4 | 5 | 28859 | 19 | |||
64817 | 57386 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 9 | Permit Number 16225 | 6008086.74583 | 2116379.20728 | 37.791630372888 | -122.415922231451 | (37.791630372888, -122.415922231451) | 5 | 1 | 10 | 28858 | 21 | ||
187862 | 62716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.43148 | 2119179.891 | 37.7992927199273 | -122.417820789314 | (37.7992927199273, -122.417820789314) | 5 | 1 | 10 | 28858 | 32 | |
34136 | 61855 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066 | (37.7540649402035, -122.40731493066) | 10 | 4 | 7 | 28859 | 19 | ||
53204 | 226720 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010300.3347 | 2102457.66674 | 37.7535292444798 | -122.407281376151 | (37.7535292444798, -122.407281376151) | 10 | 4 | 7 | 28859 | 19 | |||
65894 | 34773 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1130 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 7 | Permit Number 38414 | 6008029.42163869 | 2101336.50490812 | 37.7503234289999 | -122.41505535764 | (37.7503234289999, -122.41505535764) | 2 | 4 | 7 | 28859 | 19 | |
30922 | 61857 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | 10 | 4 | 7 | 28859 | 19 | ||
154330 | 226719 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010302.32292 | 2102389.91254 | 37.7533433177573 | -122.407269724513 | (37.7533433177573, -122.407269724513) | 10 | 4 | 7 | 28859 | 19 | |||
21563 | 227191 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1132 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997742.39239 | 2106527.65668 | 37.7639935831522 | -122.45100271692 | (37.7639935831522, -122.45100271692) | 15 | 5 | 11 | 29492 | 9 | |||
117588 | 227190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1132 Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997735.89415 | 2106562.64297 | 37.7640892746132 | -122.451027715365 | (37.7640892746132, -122.451027715365) | 15 | 5 | 11 | 29492 | 9 | |||
163861 | 227192 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1132 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997744.69092 | 2106510.18336 | 37.7639457374327 | -122.450993506942 | (37.7639457374327, -122.450993506942) | 15 | 5 | 11 | 29492 | 9 |
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) );