trees
2,180 rows where qSpecies_id = 57 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
13190 | 60028 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 10 | Permit Number 19516 | 6014481.96574 | 2112615.13715 | 37.7816525674538 | -122.393531108971 | (37.7816525674538, -122.393531108971) | 6 | 2 | 9 | 28856 | 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 | |||
131462 | 191461 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 26 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014466.47326 | 2112793.29077 | 37.782140875944 | -122.393597178563 | (37.782140875944, -122.393597178563) | 6 | 2 | 9 | 28856 | 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 | |||
27870 | 191476 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014442.93612 | 2112579.76279 | 37.7815532688034 | -122.393663657352 | (37.7815532688034, -122.393663657352) | 6 | 2 | 9 | 28856 | 6 | |||
90669 | 191462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 44 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014434.11551 | 2112764.95464 | 37.7820612733549 | -122.393707138698 | (37.7820612733549, -122.393707138698) | 6 | 2 | 9 | 28856 | 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 | |||
89619 | 191475 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014428.20557 | 2112560.71307 | 37.7815001440537 | -122.393713284646 | (37.7815001440537, -122.393713284646) | 6 | 2 | 9 | 28856 | 6 | |||
36321 | 191463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014423.52986 | 2112756.14838 | 37.7820365051332 | -122.393743143935 | (37.7820365051332, -122.393743143935) | 6 | 2 | 9 | 28856 | 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 | |||
190796 | 191464 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014410.76639 | 2112744.50721 | 37.7820038318593 | -122.393786484975 | (37.7820038318593, -122.393786484975) | 6 | 2 | 9 | 28856 | 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 | |||
84253 | 191465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014398.12583 | 2112729.40877 | 37.7819616725233 | -122.393829158687 | (37.7819616725233, -122.393829158687) | 6 | 2 | 9 | 28856 | 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 | |||
17343 | 60021 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 76 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286 | -122.393871832437 | (37.781935850286, -122.393871832437) | 6 | 2 | 9 | 28856 | 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 | |||
166744 | 40227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.01784 | 37.7813803084996 | -122.3938724152 | (37.7813803084996, -122.3938724152) | 6 | 2 | 9 | 28856 | 6 | ||
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 | |
182849 | 191466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 86 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014334.84424 | 2112669.08128 | 37.781792510069 | -122.394043861033 | (37.781792510069, -122.394043861033) | 6 | 2 | 9 | 28856 | 6 | |||
47240 | 191474 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6014326.75697 | 2112466.04784 | 37.7812345769599 | -122.39405762156 | (37.7812345769599, -122.39405762156) | 6 | 2 | 9 | 28856 | 6 | |||
26208 | 191473 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014315.40863 | 2112455.42682 | 37.7812047833188 | -122.394096137746 | (37.7812047833188, -122.394096137746) | 6 | 2 | 9 | 28856 | 6 | |||
96281 | 191467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014304.88923 | 2112665.08125 | 37.7817798619958 | -122.394147212029 | (37.7817798619958, -122.394147212029) | 6 | 2 | 9 | 28856 | 6 | |||
12964 | 60035 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.394162517581 | (37.7811490811156, -122.394162517581) | 6 | 2 | 9 | 28856 | 6 | |
48700 | 191468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014292.29593 | 2112680.88237 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | 6 | 2 | 9 | 28856 | 6 | |||
126424 | 191469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.394233893177 | (37.7818525865622, -122.394233893177) | 6 | 2 | 9 | 28856 | 6 | |||
138738 | 191470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014270.76431 | 2112702.62209 | 37.7818810438134 | -122.394267898345 | (37.7818810438134, -122.394267898345) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |
18310 | 60036 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.7810448020107 | -122.394297734267 | (37.7810448020107, -122.394297734267) | 6 | 2 | 9 | 28856 | 6 | |
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 | |
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 | |||
190472 | 60025 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 155 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.394449015999 | (37.7813091831039, -122.394449015999) | 6 | 2 | 9 | 28856 | 6 | ||
117613 | 191472 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 171 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014194.16653 | 2112375.55603 | 37.7809787369144 | -122.394509984157 | (37.7809787369144, -122.394509984157) | 6 | 2 | 9 | 28856 | 6 | |||
15001 | 60031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | 6 | 2 | 9 | 28856 | 6 | |
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
155274 | 191471 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 171 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014161.57896 | 2112368.90341 | 37.7809586586641 | -122.394622255529 | (37.7809586586641, -122.394622255529) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |
87859 | 67716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 560 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 18 | 4x9 | Permit Number 31329 | 6014049.28523 | 2112210.37006 | 37.7805171185161 | -122.394999630825 | (37.7805171185161, -122.394999630825) | 6 | 2 | 9 | 28856 | 34 |
131753 | 191447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300 Phelps St | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | 10 | 3 | 8 | 58 | 1 | |||
61580 | 67593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 357 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31160 | 6013799.73337 | 2105430.83352 | 37.7618881461485 | -122.395387878055 | (37.7618881461485, -122.395387878055) | 10 | 3 | 8 | 28856 | 29 | |
93436 | 67592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.395402814912 | (37.7619996710595, -122.395402814912) | 10 | 3 | 8 | 28856 | 29 | |
21862 | 191445 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1451 19th St | 3 | : | Tree | Private 2 | 4 | Width 4ft | 6013335.75988 | 2105192.04749 | 37.7612066758622 | -122.396975847857 | (37.7612066758622, -122.396975847857) | 10 | 3 | 8 | 28856 | 29 | |||
124454 | 57616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 455 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 11 | Permit Number 22179 | 6013266.46923 | 2104945.7243 | 37.7605264691381 | -122.397198223232 | (37.7605264691381, -122.397198223232) | 10 | 3 | 8 | 28856 | 29 | |
59540 | 62093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 421 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 12 | Permit Number 22182 | 6013256.61588 | 2105083.54347 | 37.760904341792 | -122.397241966241 | (37.760904341792, -122.397241966241) | 10 | 3 | 8 | 28856 | 29 | |
172933 | 62092 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | 10 | 3 | 8 | 28856 | 29 | ||
23799 | 62094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22183 | 6013254.03052 | 2105108.1707 | 37.7609718188263 | -122.397252634924 | (37.7609718188263, -122.397252634924) | 10 | 3 | 8 | 28856 | 29 | |
100774 | 57997 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 407 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22184 | 6013252.80923 | 2105139.22095 | 37.7610570080038 | -122.397259036287 | (37.7610570080038, -122.397259036287) | 10 | 3 | 8 | 28856 | 29 | |
109455 | 62083 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 11 | Permit Number 22167 | 6013240.89819 | 2104321.43892 | 37.7588108945258 | -122.397242884449 | (37.7588108945258, -122.397242884449) | 10 | 3 | 8 | 28856 | 29 | |
57752 | 101144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | 10 | 3 | 8 | 28856 | 29 | |||
183319 | 101143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.7605945388373 | -122.397410636805 | (37.7605945388373, -122.397410636805) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
175755 | 62091 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1401 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | Permit Number 22178 | 6013163.83149517 | 2106111.21456306 | 37.7637209341904 | -122.397634949335 | (37.7637209341904, -122.397634949335) | 14 | 3 | 8 | 28856 | 29 | ||
101328 | 191443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 19th St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6013161.12259 | 2105230.38347 | 37.7613022153415 | -122.397582536801 | (37.7613022153415, -122.397582536801) | 10 | 3 | 8 | 28856 | 29 | |||
180827 | 177075 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013151.42883 | 2086913.13616 | 37.711006322265 | -122.396332172488 | (37.711006322265, -122.396332172488) | 10 | 3 | 8 | 309 | 1 | |||
128918 | 191444 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Connecticut St | 1 | : | Tree | Private 2 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | 14 | 3 | 8 | 28856 | 29 | |||
25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
178262 | 191436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6013098.64542 | 2106113.56036 | 37.7637237451866 | -122.397860573921 | (37.7637237451866, -122.397860573921) | 14 | 3 | 8 | 28856 | 29 | |||
159386 | 177086 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 114 Gillette Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6013074.44499 | 2086867.89295 | 37.7108778091238 | -122.396595079423 | (37.7108778091238, -122.396595079423) | 10 | 3 | 8 | 309 | 1 | |||
32436 | 104687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | 10 | 3 | 8 | 309 | 1 | |||
71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
92841 | 54939 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | 10 | 3 | 8 | 309 | 1 | ||
86899 | 54938 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.42661 | 2086907.84409 | 37.7109862260136 | -122.396677435726 | (37.7109862260136, -122.396677435726) | 10 | 3 | 8 | 309 | 1 | |
103381 | 54754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 525 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | 16 | Permit Number 10602 | 6013004.6612 | 2086964.21665 | 37.7111384110727 | -122.396843018889 | (37.7111384110727, -122.396843018889) | 10 | 3 | 8 | 309 | 1 | ||
35342 | 177087 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012854.22383 | 2086908.70499 | 37.7109776122888 | -122.397359080471 | (37.7109776122888, -122.397359080471) | 10 | 3 | 8 | 309 | 1 | |||
67213 | 177076 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012816.17748 | 2087024.55768 | 37.7112936025929 | -122.397498698426 | (37.7112936025929, -122.397498698426) | 10 | 3 | 8 | 309 | 1 | |||
32141 | 177077 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012777.25506 | 2087037.01969 | 37.7113256535156 | -122.397634098541 | (37.7113256535156, -122.397634098541) | 10 | 3 | 8 | 309 | 1 | |||
173645 | 177078 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 490 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012757.34984 | 2087044.18122 | 37.7113442092312 | -122.397703398489 | (37.7113442092312, -122.397703398489) | 10 | 3 | 8 | 309 | 1 | |||
38133 | 177079 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 411 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012724.51952 | 2087052.83346 | 37.7113661383121 | -122.397817475721 | (37.7113661383121, -122.397817475721) | 10 | 3 | 8 | 309 | 1 | |||
67625 | 177080 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 411 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012673.35079 | 2087069.8441 | 37.7114099964555 | -122.397995521673 | (37.7114099964555, -122.397995521673) | 10 | 3 | 8 | 309 | 1 | |||
190049 | 191481 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012554.15249 | 2111142.66479 | 37.7775021925975 | -122.400097029578 | (37.7775021925975, -122.400097029578) | 14 | 2 | 9 | 28856 | 34 | |||
62124 | 191480 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012537.84104 | 2111160.5359 | 37.7775503530914 | -122.400154712085 | (37.7775503530914, -122.400154712085) | 14 | 2 | 9 | 28856 | 34 | |||
144669 | 191479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6012522.42576 | 2111176.28412 | 37.7775927345574 | -122.400209145359 | (37.7775927345574, -122.400209145359) | 14 | 2 | 9 | 28856 | 34 | |||
125300 | 191484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012469.2774 | 2111178.20326 | 37.7775950404069 | -122.400393139428 | (37.7775950404069, -122.400393139428) | 14 | 2 | 9 | 28856 | 34 | |||
62275 | 191483 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012443.09783 | 2111154.53509 | 37.7775285931066 | -122.400482041007 | (37.7775285931066, -122.400482041007) | 14 | 2 | 9 | 28856 | 34 | |||
186811 | 191482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012422.29694 | 2111134.3733 | 37.7774720734215 | -122.400552582046 | (37.7774720734215, -122.400552582046) | 14 | 2 | 9 | 28856 | 34 | |||
173917 | 177085 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012392.66028 | 2086405.76084 | 37.7095709179289 | -122.398919087641 | (37.7095709179289, -122.398919087641) | 10 | 3 | 8 | 309 | 1 | |||
17977 | 61561 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.400141501934 | (37.754725580248, -122.400141501934) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
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 | |||
35708 | 177074 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 250 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012293.95082 | 2087148.96015 | 37.7116060954047 | -122.399312384552 | (37.7116060954047, -122.399312384552) | 10 | 3 | 8 | 309 | 1 | |||
127544 | 191437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300x De Haro St | 31 | Median : Yard | Tree | DPW 1 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | 10 | 3 | 8 | 28856 | 29 | ||||
31281 | 177081 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012270.95689 | 2087199.03401 | 37.711742306726 | -122.39939537131 | (37.711742306726, -122.39939537131) | 10 | 3 | 8 | 309 | 1 | |||
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 | |||
24257 | 106128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6012212.28641 | 2101900.78254 | 37.7521069828692 | -122.400630274471 | (37.7521069828692, -122.400630274471) | 10 | 3 | 8 | 28856 | 29 | ||||
159719 | 191439 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2205 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.7519933949033 | -122.400702349738 | (37.7519933949033, -122.400702349738) | 10 | 3 | 8 | 28856 | 29 | |||
174377 | 191440 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2212 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6012152.29836 | 2101896.56279 | 37.7520920505116 | -122.400837427014 | (37.7520920505116, -122.400837427014) | 10 | 3 | 8 | 28856 | 29 | |||
138358 | 191438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2209 25th St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | 6012142.94506 | 2101858.42279 | 37.7519868046503 | -122.400867092959 | (37.7519868046503, -122.400867092959) | 10 | 3 | 8 | 28856 | 29 | ||||
121217 | 25707 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 582 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6012142.68592 | 2110270.08873 | 37.7750833484994 | -122.401459098675 | (37.7750833484994, -122.401459098675) | 14 | 2 | 9 | 28853 | 34 | |||
189254 | 31669 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | 10 | 3 | 8 | 309 | 1 | |||
23720 | 107959 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
129881 | 107956 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
30040 | 25706 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 582 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | 14 | 2 | 9 | 28853 | 34 | |||
129418 | 129674 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012104.09602 | 2116801.48556 | 37.7930148863658 | -122.402051854416 | (37.7930148863658, -122.402051854416) | 4 | 1 | 10 | 28854 | 6 | |||
168520 | 25705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.401607649574 | (37.7751657827012, -122.401607649574) | 14 | 2 | 9 | 28853 | 34 | |||
24736 | 191441 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.401033518791 | (37.7520763618475, -122.401033518791) | 10 | 3 | 8 | 28856 | 29 | |||
189283 | 129675 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012092.09526 | 2116799.41386 | 37.7930085281603 | -122.402093232241 | (37.7930085281603, -122.402093232241) | 4 | 1 | 10 | 28854 | 6 | |||
62433 | 25704 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | 14 | 2 | 9 | 28853 | 34 | |||
110902 | 177082 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 199 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012090.15374 | 2087257.68783 | 37.7118932795125 | -122.40002439672 | (37.7118932795125, -122.40002439672) | 10 | 3 | 8 | 309 | 1 | |||
112379 | 129676 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | 4 | 1 | 10 | 28854 | 6 | |||
85410 | 25703 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6012079.76947 | 2110324.35268 | 37.7752288341828 | -122.401680556721 | (37.7752288341828, -122.401680556721) | 14 | 2 | 9 | 28853 | 34 |
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) );