trees
3,709 rows where qSpecies_id = 9 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188793 | 182973 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2501 19th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5990445.0142 | 2098037.2692 | 37.7402607362875 | -122.475621914766 | (37.7402607362875, -122.475621914766) | 1 | 8 | 3 | 29491 | 35 | |||
188666 | 42625 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1844 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42683 | 6004409.1039 | 2115238.2303 | 37.7882900931927 | -122.42856547432 | (37.7882900931927, -122.42856547432) | 13 | 9 | 11 | 28858 | 27 | |
188653 | 18599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 449 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/1996 12:00:00 AM | 12 | 3X3 | 5992745.528 | 2088491.5039 | 37.7141835151811 | -122.466973921771 | (37.7141835151811, -122.466973921771) | 9 | 8 | 6 | 64 | 24 | ||
188614 | 233169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 820 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999150.84185 | 2107505.14096 | 37.7667580424744 | -122.446201643884 | (37.7667580424744, -122.446201643884) | 15 | 5 | 5 | 29492 | 9 | |||
188599 | 94735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 281 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 8 | 3x3 | Permit Number 53866 | 5993361.97406 | 2113605.09572 | 37.7831745861747 | -122.466667645979 | (37.7831745861747, -122.466667645979) | 11 | 6 | 2 | 54 | 11 |
188548 | 85310 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
188529 | 121343 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 399X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
188481 | 34176 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 864 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2002 12:00:00 AM | Permit Number 38002 | 6001704.33571559 | 2095884.14620219 | 37.7349950611744 | -122.436537685001 | (37.7349950611744, -122.436537685001) | 2 | 7 | 5 | 63 | 7 | ||
188345 | 22198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4049 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015622.4674 | 2097608.2349 | 37.7405101410632 | -122.388537652185 | (37.7405101410632, -122.388537652185) | 10 | 3 | 8 | 58 | 1 | |||
188302 | 210750 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1388 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5994291.08349 | 2106080.31937 | 37.7625671199022 | -122.462907225415 | (37.7625671199022, -122.462907225415) | 1 | 5 | 11 | 56 | 12 | |||
188254 | 232965 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 24 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998838.05287 | 2105417.68603 | 37.7610085471406 | -122.447133280373 | (37.7610085471406, -122.447133280373) | 15 | 5 | 11 | 29492 | 12 | |||
188212 | 177868 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002724.27928 | 2089381.75446 | 37.7171988614159 | -122.432547078085 | (37.7171988614159, -122.432547078085) | 9 | 7 | 6 | 28861 | 5 | |||
188181 | 69169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1375 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 0 | Permit Number 33206 | 5982739.37933195 | 2105771.37048825 | 37.7610466950075 | -122.502836848167 | (37.7610466950075, -122.502836848167) | 1 | 8 | 3 | 56 | 35 | |
188097 | 51081 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2330 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | Permit Number 47540 | 5999327.42209672 | 2116761.46496067 | 37.7921836047714 | -122.446256805552 | (37.7921836047714, -122.446256805552) | 13 | 6 | 1 | 29490 | 27 | |||
188067 | 233070 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 776 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001501.18561 | 2100010.82679 | 37.7463144135767 | -122.437535471792 | (37.7463144135767, -122.437535471792) | 2 | 7 | 5 | 63 | 22 | |||
188062 | 244909 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1260 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000102.3619 | 2108875.5357 | 37.7705750972769 | -122.443008930463 | (37.7705750972769, -122.443008930463) | 15 | 5 | 11 | 29492 | 9 | |||
188017 | 17905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2291 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002984.8186377 | 2115126.0213176 | 37.787901290694 | -122.4334852398 | (37.787901290694, -122.4334852398) | 13 | 9 | 11 | 29490 | 27 | |||
187994 | 232923 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1044 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004380.50848 | 2102786.98314 | 37.7541003760405 | -122.427776885991 | (37.7541003760405, -122.427776885991) | 2 | 4 | 5 | 28862 | 22 | |||
187969 | 210666 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 461 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993758.36783 | 2101793.87252 | 37.7507669453544 | -122.464438441679 | (37.7507669453544, -122.464438441679) | 1 | 8 | 4 | 29491 | 40 | |||
187902 | 210618 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1351 06th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5994232.91886 | 2106322.09436 | 37.7632276206897 | -122.463125937836 | (37.7632276206897, -122.463125937836) | 1 | 5 | 11 | 56 | 12 | |||
187885 | 251033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5055 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 5991301.1722 | 2112656.9502 | 37.7804520972921 | -122.473727928995 | (37.7804520972921, -122.473727928995) | 11 | 6 | 2 | 54 | 26 | |||
187882 | 11147 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
187837 | 233629 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008888.11945 | 2102842.17594 | 37.7545058812444 | -122.412192313948 | (37.7545058812444, -122.412192313948) | 2 | 4 | 7 | 28859 | 19 | |||
187826 | 210811 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 481 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994784.95853 | 2100015.28605 | 37.7459425187304 | -122.460759544543 | (37.7459425187304, -122.460759544543) | 1 | 8 | 4 | 59 | 40 | |||
187824 | 17890 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2237 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003209.8546 | 2115154.5824 | 37.7879924771756 | -122.432708698198 | (37.7879924771756, -122.432708698198) | 13 | 9 | 11 | 29490 | 27 | |||
187683 | 233616 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 332 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007179.95505 | 2105346.60016 | 37.7612864574232 | -122.418277162854 | (37.7612864574232, -122.418277162854) | 2 | 4 | 7 | 28859 | 19 | |||
187657 | 194203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 485 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013979.41846 | 2112620.06664 | 37.7816381665966 | -122.395270042584 | (37.7816381665966, -122.395270042584) | 6 | 2 | 9 | 28856 | 6 | |||
187631 | 123847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 26 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995467.65925 | 2114952.32534 | 37.7869950091238 | -122.459480476042 | (37.7869950091238, -122.459480476042) | 11 | 6 | 1 | 54 | 11 | |||
187554 | 124396 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5996009.83967 | 2115561.95106 | 37.7887000369005 | -122.457648792322 | (37.7887000369005, -122.457648792322) | 11 | 6 | 1 | 54 | 31 | |||
187546 | 59397 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 590 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33158 | 6002950.30389667 | 2095729.2857733 | 37.7346405741685 | -122.432218878731 | (37.7346405741685, -122.432218878731) | 2 | 7 | 5 | 63 | 7 | ||
187451 | 232925 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 369 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004149.17175 | 2098945.97358 | 37.7435407676884 | -122.428303169249 | (37.7435407676884, -122.428303169249) | 2 | 7 | 5 | 63 | 22 | |||
187439 | 233000 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 355 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006979.01967 | 2096047.19931 | 37.7357410959584 | -122.418312748137 | (37.7357410959584, -122.418312748137) | 2 | 7 | 7 | 28859 | 2 | |||
187436 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | |||
187253 | 246727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 159 Ripley St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6008928.07801 | 2099130.49875 | 37.7443166847779 | -122.411791871004 | (37.7443166847779, -122.411791871004) | 2 | 7 | 7 | 28859 | 2 | |||
187203 | 184036 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984928.8265 | 2103810.0952 | 37.7557900106144 | -122.495119982258 | (37.7557900106144, -122.495119982258) | 1 | 8 | 3 | 56 | 35 | |||
187192 | 182410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1522 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985613.4353 | 2104824.559 | 37.7586155044304 | -122.492827136387 | (37.7586155044304, -122.492827136387) | 1 | 8 | 3 | 56 | 35 | |||
187180 | 177959 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989083.70402 | 2089208.46347 | 37.7159400713658 | -122.479682885652 | (37.7159400713658, -122.479682885652) | 1 | 8 | 4 | 64 | 14 | ||||
187167 | 132022 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 928 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007892.79628 | 2120308.15692 | 37.8024073851468 | -122.416871780604 | (37.8024073851468, -122.416871780604) | 5 | 1 | 1 | 308 | 32 | |||
187149 | 122043 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 273 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5990230.38035 | 2113566.84786 | 37.7828883484336 | -122.477498784299 | (37.7828883484336, -122.477498784299) | 11 | 6 | 2 | 55 | 26 | |||
187097 | 68312 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 317 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 32125 | 6008478.92356277 | 2113549.85659858 | 37.7838837035226 | -122.414365013766 | (37.7838837035226, -122.414365013766) | 7 | 10 | 9 | 28858 | 36 | ||
187051 | 244180 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 418 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5998446.5814 | 2109068.6947 | 37.7710109186636 | -122.448750181778 | (37.7710109186636, -122.448750181778) | 15 | 5 | 11 | 29492 | 9 | |||
187048 | 194222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012957.45228 | 2090084.12895 | 37.7197024427026 | -122.397224821584 | (37.7197024427026, -122.397224821584) | 10 | 3 | 8 | 58 | 1 | |||
187039 | 210670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2043 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5992072.8451 | 2095394.57666 | 37.7330988041578 | -122.469801226772 | (37.7330988041578, -122.469801226772) | 9 | 8 | 4 | 59 | 40 | |||
187015 | 119134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 507 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5981280.05518 | 2112253.74511 | 37.7787595315686 | -122.508365127423 | (37.7787595315686, -122.508365127423) | 11 | 6 | 2 | 55 | 26 | |||
186985 | 232982 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998169.85429 | 2104895.59197 | 37.7595368065886 | -122.4494066595 | (37.7595368065886, -122.4494066595) | 15 | 5 | 11 | 28862 | 12 | |||
186888 | 233710 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 82 Hancock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6003731.7602 | 2105107.2951 | 37.7604346816273 | -122.430185936829 | (37.7604346816273, -122.430185936829) | 2 | 4 | 5 | 28862 | 3 | |||
186815 | 46879 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2300@Green Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44939 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | ||
186638 | 233631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2412 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008814.85416 | 2104268.0424 | 37.7584168763487 | -122.412546472365 | (37.7584168763487, -122.412546472365) | 2 | 4 | 7 | 28859 | 19 | |||
186623 | 257921 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
186622 | 252932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 66 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091179 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | 9 | 8 | 6 | 28861 | 24 | |||||
186596 | 56403 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 13 | Permit Number 12560 | 5992110.08435 | 2113911.71071 | 37.7839441413533 | -122.471020983366 | (37.7839441413533, -122.471020983366) | 11 | 6 | 2 | 54 | 11 | ||
186466 | 210706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994003.39155 | 2089200.86992 | 37.7162037876449 | -122.462677719319 | (37.7162037876449, -122.462677719319) | 9 | 8 | 6 | 64 | 24 | |||
186449 | 88402 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 824 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53739 | 6009046.47564 | 2119079.80908 | 37.7990994718157 | -122.412792574519 | (37.7990994718157, -122.412792574519) | 3 | 1 | 10 | 308 | 32 |
185942 | 210769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1411 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994248.7143 | 2105878.1613 | 37.7620096058699 | -122.463039095698 | (37.7620096058699, -122.463039095698) | 1 | 5 | 11 | 56 | 12 | |||
185820 | 233696 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 117 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004357.13471 | 2101587.81989 | 37.7508064318812 | -122.427772281479 | (37.7508064318812, -122.427772281479) | 2 | 4 | 5 | 28862 | 22 | |||
185718 | 87102 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2150 Post St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | 3x3 | Permit Number 43711 | 6001880 | 2113982 | 37.7846973562433 | -122.437225758313 | (37.7846973562433, -122.437225758313) | 13 | 6 | 11 | 29490 | 13 | ||
185703 | 9729 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 633 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005786.04675 | 2111952.13361 | 37.7793451083039 | -122.423567751964 | (37.7793451083039, -122.423567751964) | 7 | 9 | 11 | 28852 | 41 | |||
185633 | 38331 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 346 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | 8 | Permit Number 40385 | 6007360.11088377 | 2107658.94238864 | 37.7676457487192 | -122.417817990969 | (37.7676457487192, -122.417817990969) | 8 | 4 | 7 | 28853 | 19 | |
185540 | 31048 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 5 | Permit Number 34804 | 6002823.26013 | 2087491.091 | 37.7120131267777 | -122.432070011132 | (37.7120131267777, -122.432070011132) | 9 | 7 | 6 | 28861 | 5 | |
185531 | 114738 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
185447 | 43390 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801X Elizabeth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2000 12:00:00 AM | 12 | 4x4 | Permit Number 43135 | 6001254.81966584 | 2101756.31685546 | 37.7510931027947 | -122.438512414569 | (37.7510931027947, -122.438512414569) | 2 | 4 | 5 | 28862 | 22 | |
185402 | 177881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 490 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010189.89814 | 2089698.96953 | 37.7184904092754 | -122.406764185036 | (37.7184904092754, -122.406764185036) | 10 | 7 | 8 | 309 | 39 | |||
185332 | 12929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6481X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013096.23046 | 2090034.75353 | 37.7195745928355 | -122.396741651947 | (37.7195745928355, -122.396741651947) | 10 | 3 | 8 | 58 | 1 | |||
185313 | 232935 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003842.87977 | 2100908.6404 | 37.7489124596543 | -122.429502190372 | (37.7489124596543, -122.429502190372) | 2 | 4 | 5 | 28862 | 22 | |||
185178 | 98910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2320 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768683 | 6002441.12486 | 2117804.92539 | 37.795226009917 | -122.435558039776 | (37.795226009917, -122.435558039776) | 13 | 9 | 1 | 57 | 17 | |
185110 | 131974 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1354 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006426.93958 | 2119751.48966 | 37.8007963576324 | -122.421904809461 | (37.8007963576324, -122.421904809461) | 13 | 9 | 1 | 28858 | 32 | |||
185007 | 187679 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||||
185004 | 131814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145 Capra Way | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6001091.88484 | 2120522.16453 | 37.80261010672 | -122.440421585107 | (37.80261010672, -122.440421585107) | 13 | 9 | 1 | 57 | 17 | |||
184974 | 18064 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2902 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/1997 12:00:00 AM | 12 | 3X3 | 6000013.6639 | 2114768.6486 | 37.7867510196451 | -122.44373917398 | (37.7867510196451, -122.44373917398) | 15 | 6 | 1 | 29490 | 31 | ||
184862 | 147685 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 685 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5991279.80813 | 2110776.85562 | 37.7752886354907 | -122.473664648618 | (37.7752886354907, -122.473664648618) | 11 | 6 | 2 | 54 | 26 | |||
184849 | 233809 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 83 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006776.89182 | 2109465.42197 | 37.7725730741221 | -122.419963484333 | (37.7725730741221, -122.419963484333) | 8 | 2 | 9 | 28853 | 19 | |||
184816 | 233106 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000602.06927 | 2102095.20049 | 37.751986443124 | -122.440793993463 | (37.751986443124, -122.440793993463) | 2 | 4 | 5 | 28862 | 22 | |||
184762 | 131812 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2099 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999306.86195 | 2121143.68392 | 37.8042148317993 | -122.446643381002 | (37.8042148317993, -122.446643381002) | 13 | 9 | 1 | 57 | 17 | |||
184736 | 111773 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5998285.1385 | 2109899.1988 | 37.7732820368573 | -122.449368462439 | (37.7732820368573, -122.449368462439) | 15 | 5 | 11 | 29492 | 16 | |||
184641 | 131921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1819 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006088.92452 | 2116261.91579 | 37.7911957989053 | -122.422826344777 | (37.7911957989053, -122.422826344777) | 13 | 9 | 1 | 28858 | 27 | |||
184477 | 45597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1770 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2001 12:00:00 AM | 7 | Permit Number 44332 | 5985361.4044 | 2103173.351 | 37.7540670019119 | -122.493577094797 | (37.7540670019119, -122.493577094797) | 1 | 8 | 3 | 56 | 35 | |
184465 | 131953 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005982.71631 | 2120039.55132 | 37.8015622391594 | -122.423462499999 | (37.8015622391594, -122.423462499999) | 5 | 9 | 1 | 28858 | 32 | |||
184399 | 233011 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 321 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006469.42863 | 2098011.03198 | 37.7411046445645 | -122.420213940117 | (37.7411046445645, -122.420213940117) | 2 | 7 | 7 | 28859 | 2 | |||
184338 | 233758 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003137.60569 | 2107983.50459 | 37.7682983859983 | -122.432446276667 | (37.7682983859983, -122.432446276667) | 15 | 5 | 5 | 28862 | 3 | |||
184267 | 84317 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 726 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50082 | 5987577.5993 | 2110987.96812 | 37.7756531834162 | -122.48648677814 | (37.7756531834162, -122.48648677814) | 11 | 6 | 2 | 55 | 26 | |
184092 | 187618 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993007 | 2088191 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | 9 | 8 | 6 | 64 | 24 | ||||
184089 | 232921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3893 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004555.54472 | 2101310.92021 | 37.7500573514658 | -122.427066441373 | (37.7500573514658, -122.427066441373) | 2 | 4 | 5 | 28862 | 22 | |||
184070 | 131803 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2498 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999450.12421 | 2119820.05848 | 37.8005886951794 | -122.446052350134 | (37.8005886951794, -122.446052350134) | 13 | 9 | 1 | 57 | 17 | |||
184056 | 52275 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1552DUNCAN Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48437 | 6005878.21118705 | 2099920.68685133 | 37.746314793518 | -122.422393813069 | (37.746314793518, -122.422393813069) | 2 | 7 | 5 | 28859 | 22 | ||
184038 | 182411 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1522 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985613.8208 | 2104844.1281 | 37.7586692583075 | -122.492827244542 | (37.7586692583075, -122.492827244542) | 1 | 8 | 3 | 56 | 35 | |||
184030 | 131959 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005892.60072 | 2120026.32427 | 37.8015208343873 | -122.423773400141 | (37.8015208343873, -122.423773400141) | 5 | 9 | 1 | 28858 | 32 | |||
183993 | 177854 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 701 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6000936.66084 | 2089691.6636 | 37.7179482664819 | -122.43874821026 | (37.7179482664819, -122.43874821026) | 9 | 7 | 6 | 28861 | 5 | ||||
183970 | 104071 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 590 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770130 | 5985063.18032 | 2111850.11147 | 37.7778734932803 | -122.495248237578 | (37.7778734932803, -122.495248237578) | 11 | 6 | 2 | 55 | 26 | |
183912 | 11163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | 5 | 1 | 1 | 28858 | 32 | |||
183842 | 233195 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 799 Moultrie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007611.39473 | 2095781.55504 | 37.7350472717153 | -122.416107568209 | (37.7350472717153, -122.416107568209) | 2 | 7 | 7 | 28859 | 2 | |||
183836 | 210697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995068.3011 | 2091117.15656 | 37.7215267291452 | -122.459135584749 | (37.7215267291452, -122.459135584749) | 9 | 8 | 6 | 28861 | 24 | |||
183822 | 233678 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003365.61378 | 2101285.1218 | 37.7499191553438 | -122.431179444895 | (37.7499191553438, -122.431179444895) | 2 | 4 | 5 | 28862 | 22 | |||
183808 | 108623 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 399X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x16 | 6004869 | 2101687 | 37.7511076995848 | -122.426009263621 | (37.7511076995848, -122.426009263621) | 2 | 4 | 5 | 28862 | 22 | |||
183802 | 33868 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 199 Montcalm St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | Permit Number 37861 | 6010103.23973562 | 2099711.91394451 | 37.74597898005 | -122.407769380972 | (37.74597898005, -122.407769380972) | 2 | 7 | 7 | 28859 | 2 | |||
183751 | 69422 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 550 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1994 12:00:00 AM | Permit Number 33527 | 6008943.51120006 | 2105665.71504955 | 37.762261786244 | -122.412200298919 | (37.762261786244, -122.412200298919) | 8 | 4 | 7 | 28859 | 19 | ||
183707 | 9733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 649 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005777.60667 | 2112009.54549 | 37.7795022709045 | -122.423601032727 | (37.7795022709045, -122.423601032727) | 7 | 9 | 11 | 28852 | 41 | |||
183702 | 118178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 727 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985673.20128 | 2110928.01346 | 37.7753773719698 | -122.493070048484 | (37.7753773719698, -122.493070048484) | 11 | 6 | 2 | 55 | 26 | |||
183608 | 232984 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 60 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5998238.97137 | 2106560.94652 | 37.7641134052337 | -122.449287603655 | (37.7641134052337, -122.449287603655) | 15 | 5 | 11 | 29492 | 9 | |||
183584 | 131909 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2435 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000742.0831 | 2116721.51113 | 37.7921545922154 | -122.44135920027 | (37.7921545922154, -122.44135920027) | 13 | 6 | 1 | 29490 | 27 | |||
183582 | 62098 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 263 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51774 | 6013213.82245 | 2105839.16693 | 37.7629767350191 | -122.397442964743 | (37.7629767350191, -122.397442964743) | 14 | 3 | 8 | 28856 | 29 |
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) );