trees
2,180 rows where qSpecies_id = 57 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |
4770 | 191477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6014491.1655 | 2112621.09872 | 37.7816694477368 | -122.393499699264 | (37.7816694477368, -122.393499699264) | 6 | 2 | 9 | 28856 | 6 | |||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
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 | |||
7855 | 60037 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 84 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | 6 | 2 | 9 | 28856 | 6 | |
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |||
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 | |
9894 | 60029 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.393315638611 | (37.7818164104522, -122.393315638611) | 6 | 2 | 9 | 28856 | 6 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |
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 | |||
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 | |
24120 | 103523 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
35183 | 15320 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.7704658809505 | -122.419909204722 | (37.7704658809505, -122.419909204722) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
39167 | 227506 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Otis St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006716.29525 | 2108893.94632 | 37.7710005240788 | -122.420132529885 | (37.7710005240788, -122.420132529885) | 8 | 2 | 9 | 28853 | 19 | |||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
43925 | 112146 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 299X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011616 | 2112272 | 37.7805507327562 | -122.403421899857 | (37.7805507327562, -122.403421899857) | 6 | 2 | 9 | 28853 | 34 | |||
45757 | 201240 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 832 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6011987.3715 | 2112559.9702 | 37.7813621675722 | -122.402157393633 | (37.7813621675722, -122.402157393633) | 6 | 2 | 9 | 28853 | 34 | |||
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 | |||
47478 | 68437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.413666857651 | (37.7752540178903, -122.413666857651) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
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 | |||
55363 | 191486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 347 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011893.8519 | 2112710.62909 | 37.7817706214524 | -122.402491524862 | (37.7817706214524, -122.402491524862) | 6 | 2 | 9 | 28853 | 34 | |||
56278 | 227508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006644.81895 | 2109605.92162 | 37.7729514108221 | -122.420430313409 | (37.7729514108221, -122.420430313409) | 8 | 2 | 9 | 28853 | 19 | |||
57854 | 227510 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.7732543654386 | -122.420825392799 | (37.7732543654386, -122.420825392799) | 8 | 2 | 9 | 28853 | 19 | |||
60491 | 227507 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 78 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006662.68149 | 2109606.33946 | 37.7729535646992 | -122.420368554271 | (37.7729535646992, -122.420368554271) | 8 | 2 | 9 | 28853 | 19 | |||
61099 | 142797 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 699 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007064.6918 | 2113244.5216 | 37.7829657823409 | -122.419236076253 | (37.7829657823409, -122.419236076253) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |||
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 | |||
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 | |||
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 | |||
66593 | 112141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.7805436673854 | -122.403586031292 | (37.7805436673854, -122.403586031292) | 6 | 2 | 9 | 28853 | 34 | |||
67489 | 191489 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008631.45432 | 2110388.01646 | 37.7752106112282 | -122.41361360519 | (37.7752106112282, -122.41361360519) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
71975 | 63893 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435 | 2109828 | 37.7735493586958 | -122.421171875993 | (37.7735493586958, -122.421171875993) | 8 | 2 | 9 | 28853 | 19 | ||
76720 | 227517 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1173 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006514.95028 | 2109636.302 | 37.7730275087506 | -122.420881702949 | (37.7730275087506, -122.420881702949) | 8 | 2 | 9 | 28853 | 19 | |||
77590 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 99X Cleveland St | 3 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||
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 | |||
78494 | 227512 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1175 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6006402.46798 | 2109528.79831 | 37.7727259885484 | -122.421263158476 | (37.7727259885484, -122.421263158476) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
82663 | 191491 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008660.87674 | 2110356.51617 | 37.7751257709745 | -122.413509597713 | (37.7751257709745, -122.413509597713) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
85101 | 89033 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 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 | |||
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 | |||
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 |
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 | |||
90539 | 191478 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014500.76851 | 2112629.04154 | 37.7816917904788 | -122.393467033175 | (37.7816917904788, -122.393467033175) | 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 | |||
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 | |||
98939 | 191509 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 905 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008110 | 2110227 | 37.7747392032863 | -122.415406037323 | (37.7747392032863, -122.415406037323) | 8 | 2 | 9 | 28853 | 34 | |||
99709 | 27655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.7703804801687 | -122.419945578015 | (37.7703804801687, -122.419945578015) | 8 | 2 | 9 | 28853 | 19 | |||
100778 | 191508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 55 Sherman St | 25 | : | Tree | Private 2 | 3 | Width 10ft | 6010631.50278 | 2111081.40715 | 37.7772266061547 | -122.406743828871 | (37.7772266061547, -122.406743828871) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
104018 | 227514 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1175 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006464.67083 | 2109591.57876 | 37.7729018752621 | -122.421052450024 | (37.7729018752621, -122.421052450024) | 8 | 2 | 9 | 28853 | 19 | |||
107511 | 191490 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008642.47534 | 2110374.13795 | 37.7751731229713 | -122.413574499063 | (37.7751731229713, -122.413574499063) | 8 | 2 | 9 | 28853 | 34 | |||
109097 | 27658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
113620 | 103524 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
116491 | 249354 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008321.82308 | 2114687.6754 | 37.7869990523159 | -122.414989085893 | (37.7869990523159, -122.414989085893) | 13 | 1 | 9 | 28858 | 36 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
130137 | 17345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 175X Otis St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
139092 | 60030 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 19 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19518 | 6014680.95467774 | 2112862.0838824 | 37.7823416816232 | -122.392859978153 | (37.7823416816232, -122.392859978153) | 6 | 2 | 9 | 28856 | 6 | ||
140907 | 15323 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1698X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
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 | |||
149604 | 227518 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1173 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006531.79577 | 2109651.12088 | 37.7730691473468 | -122.420824484463 | (37.7730691473468, -122.420824484463) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
156917 | 201238 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 832 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6012024.4623 | 2112592.9398 | 37.7814547646501 | -122.402031395264 | (37.7814547646501, -122.402031395264) | 6 | 2 | 9 | 28853 | 34 | |||
157001 | 227509 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006621.39205 | 2109628.6264 | 37.7730124325176 | -122.420512962002 | (37.7730124325176, -122.420512962002) | 8 | 2 | 9 | 28853 | 19 | |||
159307 | 15312 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
163511 | 15325 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1698X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 1X1 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
163617 | 89035 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 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 |
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) );