Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126497 | 126497 | 53524 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 226 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1969 12:00:00 AM | 3 | 3x3 | Permit Number 6436 | 5994753.48246338 | 2088426.05628518 | 37.714119504092295 | -122.460028964628 | (37.7141195040923, -122.460028964628) | |
| 18458 | 18458 | 17241 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169004 | -122.46296410647699 | (37.714215535169, -122.462964106477) | |||
| 17167 | 17167 | 2165 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.714210032770296 | -122.46381723495199 | (37.7142100327703, -122.463817234952) | ||
| 20302 | 20302 | 18587 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 301 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993176.8455 | 2088486.1085 | 37.7141935864691 | -122.4654827422 | (37.7141935864691, -122.4654827422) | ||
| 22105 | 22105 | 18599 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 449 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 12 | 3X3 | 5992745.528 | 2088491.5039 | 37.714183515181105 | -122.46697392177099 | (37.7141835151811, -122.466973921771) | ||
| 18586 | 18586 | 18605 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 533 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992541.0363 | 2088494.6252 | 37.714180280350796 | -122.467680944889 | (37.7141802803508, -122.467680944889) | |||
| 21515 | 21515 | 18601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992650.5887 | 2088494.9319999998 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | |||
| 84790 | 84790 | 76728 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 108493 | 108493 | 76768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 109410 | 109410 | 76771 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 112829 | 112829 | 76757 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
| 17159 | 17159 | 18616 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.46921850171199 | (37.7141600639726, -122.469218501712) | |||
| 18903 | 18903 | 18615 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992139.1908 | 2088496.6198 | 37.714162546412894 | -122.46907001084699 | (37.7141625464129, -122.469070010847) | |||
| 17690 | 17690 | 18609 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.714178026974395 | -122.468168999945 | (37.7141780269744, -122.468168999945) | |||
| 22243 | 22243 | 18613 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 645 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992222.8127 | 2088500.1488 | 37.7141770675516 | -122.46878124052799 | (37.7141770675516, -122.468781240528) | |||
| 95198 | 95198 | 31169 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34870 | 5992182.10994821 | 2088503.70058995 | 37.7141844683459 | -122.468922182021 | (37.7141844683459, -122.468922182021) | |
| 21580 | 21580 | 18574 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 24 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993864.1289 | 2088541.8084 | 37.7143861403954 | -122.463111281888 | (37.7143861403954, -122.463111281888) | |||
| 17502 | 17502 | 18578 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | |||
| 63995 | 63995 | 80365 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 500 Campbell Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 1 | 6010298.5826900005 | 2088549.9300799998 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | ||
| 20536 | 20536 | 18595 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992880.7313 | 2088552.7580000001 | 37.7143595070954 | -122.466511060282 | (37.7143595070954, -122.466511060282) | |||
| 17855 | 17855 | 18594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | |||
| 99793 | 99793 | 98885 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5994871.8 | 2088553.5 | 37.714476238810704 | -122.459629241673 | (37.7144762388107, -122.459629241673) | ||
| 20751 | 20751 | 18600 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1992 12:00:00 AM | 6 | 3X3 | 5992650.7421 | 2088555.8456 | 37.7143547106063 | -122.467306211311 | (37.7143547106063, -122.467306211311) | ||
| 166403 | 166403 | 177883 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 502 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010280.18784 | 2088557.91427 | 37.7153623567706 | -122.40637173348999 | (37.7153623567706, -122.40637173349) | |||
| 18414 | 18414 | 18611 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 618 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992335.2804 | 2088560.1418 | 37.714348290692705 | -122.468396874173 | (37.7143482906927, -122.468396874173) | |||
| 25299 | 25299 | 177894 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.715397218989104 | -122.406185898468 | (37.7153972189891, -122.406185898468) | |||
| 172579 | 172579 | 177893 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010340.10601 | 2088584.08173 | 37.7154375589705 | -122.40616647132099 | (37.7154375589705, -122.406166471321) | |||
| 54646 | 54646 | 177892 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010348.8749400005 | 2088600.69344 | 37.7154836618219 | -122.406137331491 | (37.7154836618219, -122.406137331491) | |||
| 40155 | 40155 | 177891 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010352.02594 | 2088617.41992 | 37.7155297655706 | -122.406127617893 | (37.7155297655706, -122.406127617893) | |||
| 70994 | 70994 | 177890 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 350 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010359.41892 | 2088635.45885 | 37.715579710305704 | -122.406103334421 | (37.7155797103057, -122.406103334421) | |||
| 79780 | 79780 | 53477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 310 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 14 | 4x5 | Permit Number 6386 | 5994039.73667493 | 2088736.05427739 | 37.7149296078016 | -122.462518397729 | (37.7149296078016, -122.462518397729) | |
| 65753 | 65753 | 210711 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 310 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994028.62821 | 2088760.05738 | 37.714994874884795 | -122.46255853306101 | (37.7149948748848, -122.462558533061) | |||
| 32045 | 32045 | 210733 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 239 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992956.15258 | 2088805.3429599998 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | |||
| 181597 | 181597 | 177860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999854.501540001 | 2088904.19241 | 37.715724424706394 | -122.44243224526699 | (37.7157244247064, -122.442432245267) | |||
| 12214 | 12214 | 15831 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5179 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1995 12:00:00 AM | 6 | 3X3 | 6000153.213380001 | 2088921.93918 | 37.715790175057 | -122.441401035832 | (37.715790175057, -122.441401035832) | ||
| 40016 | 40016 | 103877 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 791 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 7x9 | 6002369.63002 | 2088931.5267299998 | 37.7159425175008 | -122.433740770734 | (37.7159425175008, -122.433740770734) | |||
| 149147 | 149147 | 177935 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989493.36658 | 2088932.77712 | 37.715206894553795 | -122.47824676997699 | (37.7152068945538, -122.478246769977) | ||||
| 176036 | 176036 | 177936 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5989491.06081 | 2088964.9371200001 | 37.715295064093205 | -122.478257089699 | (37.7152950640932, -122.478257089699) | ||||
| 172901 | 172901 | 177937 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.47827153820299 | (37.7153620069155, -122.478271538203) | ||||
| 130538 | 130538 | 177963 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5988967.059330001 | 2088996.0962599998 | 37.7153501871281 | -122.48007052675501 | (37.7153501871281, -122.480070526755) | ||||
| 156935 | 156935 | 210734 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 270 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992990.46687 | 2089001.9103599999 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | |||
| 45156 | 45156 | 177964 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988925.38088 | 2089008.91353 | 37.715382958419106 | -122.48021552173901 | (37.7153829584191, -122.480215521739) | ||||
| 165423 | 165423 | 210735 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 274 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992991.6057 | 2089025.5479400002 | 37.7156640721019 | -122.466162174951 | (37.7156640721019, -122.466162174951) | |||
| 143501 | 143501 | 32741 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 234 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43375 | 5994675.9266539 | 2089047.50718001 | 37.715821400235704 | -122.460342025585 | (37.7158214002357, -122.460342025585) | ||
| 184364 | 184364 | 177938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989480.9198900005 | 2089050.18574 | 37.71552854698071 | -122.478298370392 | (37.7155285469807, -122.478298370392) | ||||
| 76083 | 76083 | 210736 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 279 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992958.0876400005 | 2089050.23377 | 37.715729919564794 | -122.466279820655 | (37.7157299195648, -122.466279820655) | |||
| 156149 | 156149 | 210737 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 283 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992959.06004 | 2089081.2292400002 | 37.7158150817716 | -122.466278710897 | (37.7158150817716, -122.466278710897) | |||
| 116415 | 116415 | 105994 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 131 GRIJALVA DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989195.7 | 2089107.3 | 37.7156688070552 | -122.479288383095 | (37.7156688070552, -122.479288383095) | ||||
| 91813 | 91813 | 60468 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 153 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20061 | 5996949.68072772 | 2089116.47275902 | 37.716141297807106 | -122.452487894641 | (37.7161412978071, -122.452487894641) | ||
| 27126 | 27126 | 177939 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | ||||
| 38107 | 38107 | 210738 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 291 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992961.95972 | 2089127.5323299998 | 37.7159423862175 | -122.46627205143999 | (37.7159423862175, -122.46627205144) | |||
| 51889 | 51889 | 177940 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989427.62768 | 2089128.0215200002 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | ||||
| 67763 | 67763 | 177962 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989078.7127 | 2089134.3997099998 | 37.7157364207672 | -122.479694721656 | (37.7157364207672, -122.479694721656) | ||||
| 155648 | 155648 | 210710 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 389 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994002.44073 | 2089155.53894 | 37.7160792648303 | -122.462677719297 | (37.7160792648303, -122.462677719297) | |||
| 146613 | 146613 | 177923 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988561.02848 | 2089156.81478 | 37.715767879956104 | -122.481485695422 | (37.7157678799561, -122.481485695422) | ||||
| 83099 | 83099 | 210709 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 389 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994001.88114 | 2089168.33159 | 37.7161143581664 | -122.462680580956 | (37.7161143581664, -122.462680580956) | |||
| 58315 | 58315 | 177961 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989118.28423 | 2089183.8613200001 | 37.7158745287534 | -122.479561562622 | (37.7158745287534, -122.479561562622) | ||||
| 151780 | 151780 | 210708 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 401 Orizaba Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5993993.93281 | 2089184.1647700001 | 37.7161573745291 | -122.462709201884 | (37.7161573745291, -122.462709201884) | |||
| 187879 | 187879 | 210707 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 401 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994004.02055 | 2089191.37438 | 37.716177751384 | -122.46267485678601 | (37.716177751384, -122.462674856786) | |||
| 173704 | 173704 | 177960 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989129.76935 | 2089200.6687 | 37.7159213447791 | -122.47952309413701 | (37.7159213447791, -122.479523094137) | ||||
| 61034 | 61034 | 210706 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 401 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994003.39155 | 2089200.86992 | 37.71620378764489 | -122.462677719319 | (37.7162037876449, -122.462677719319) | |||
| 85696 | 85696 | 46748 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | |||
| 89243 | 89243 | 46747 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | ||
| 97999 | 97999 | 46744 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | |||
| 116098 | 116098 | 46746 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | ||
| 124056 | 124056 | 46745 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 24 Sargent St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | ||
| 51581 | 51581 | 177959 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989083.70402 | 2089208.46347 | 37.71594007136579 | -122.47968288565201 | (37.7159400713658, -122.479682885652) | ||||
| 27324 | 27324 | 50494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 821 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2014 12:00:00 AM | 1 | Permit Number 772457 | 6003014.84349 | 2089242.8830799998 | 37.7168340244398 | -122.43153282718201 | (37.7168340244398, -122.431532827182) | |
| 67404 | 67404 | 177922 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990625.846609999 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | |||
| 72659 | 72659 | 177921 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.47431916261499 | (37.7161606912434, -122.474319162615) | |||
| 41979 | 41979 | 210728 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 113 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997053.85221 | 2089279.44742 | 37.716594756218 | -122.45213958229999 | (37.716594756218, -122.4521395823) | |||
| 70010 | 70010 | 177934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | ||||
| 174720 | 174720 | 177957 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989199.228490001 | 2089287.00846 | 37.7161624467126 | -122.479289326156 | (37.7161624467126, -122.479289326156) | ||||
| 136472 | 136472 | 177941 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Josepha Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5989724.378719999 | 2089308.8326299998 | 37.7162528573591 | -122.47747576951599 | (37.7162528573591, -122.477475769516) | ||||
| 175833 | 175833 | 177958 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989169.01716 | 2089315.78059 | 37.7162396930894 | -122.479395853531 | (37.7162396930894, -122.479395853531) | ||||
| 148235 | 148235 | 177933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988685.34824 | 2089320.7162799998 | 37.7162251402652 | -122.481067988213 | (37.7162251402652, -122.481067988213) | ||||
| 140978 | 140978 | 60462 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 113 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20048 | 5997094.17901268 | 2089323.97099125 | 37.7167193175881 | -122.45200340389098 | (37.7167193175881, -122.452003403891) | ||
| 167311 | 167311 | 177870 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 539 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003581.97685 | 2089338.6590099998 | 37.7171291324866 | -122.42957935221202 | (37.7171291324866, -122.429579352212) | |||
| 135710 | 135710 | 177932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988789.67714 | 2089358.2569799998 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | ||||
| 76298 | 76298 | 177869 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 700 France Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002755.5061800005 | 2089362.7676 | 37.717148498479204 | -122.43243778620001 | (37.7171484984792, -122.4324377862) | |||
| 131812 | 131812 | 177931 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988808.760919999 | 2089375.86435 | 37.716383736599205 | -122.480645454328 | (37.7163837365992, -122.480645454328) | ||||
| 43683 | 43683 | 177868 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 700 France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002724.27928 | 2089381.7544599997 | 37.717198861415895 | -122.43254707808501 | (37.7171988614159, -122.432547078085) | |||
| 63990 | 63990 | 177867 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 700 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002692.71234 | 2089400.4254400001 | 37.7172483376296 | -122.432657522924 | (37.7172483376296, -122.432657522924) | |||
| 100885 | 100885 | 177956 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989293.3686 | 2089406.92644 | 37.7164971788871 | -122.47897270272301 | (37.7164971788871, -122.478972702723) | ||||
| 69696 | 69696 | 177930 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | ||||
| 149588 | 149588 | 177942 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Josepha Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5989710.75871 | 2089436.6850700001 | 37.7166031181237 | -122.477532185763 | (37.7166031181237, -122.477532185763) | ||||
| 61899 | 61899 | 177929 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988839.75679 | 2089455.3276 | 37.7166037242653 | -122.48054413220699 | (37.7166037242653, -122.480544132207) | ||||
| 178623 | 178623 | 177928 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5988855.6313 | 2089468.65527 | 37.716641241284705 | -122.480490237638 | (37.7166412412847, -122.480490237638) | ||||
| 29723 | 29723 | 177927 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | ||||
| 65659 | 65659 | 177955 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5989333.41698 | 2089519.4632700002 | 37.7168085025868 | -122.478842503398 | (37.7168085025868, -122.478842503398) | ||||
| 184096 | 184096 | 84677 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 218 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53575 | 5998816.90097 | 2089525.7076700001 | 37.7173717668583 | -122.44606333266 | (37.7173717668583, -122.44606333266) | |
| 61160 | 61160 | 177926 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5988935.7978 | 2089543.3512799998 | 37.7168509964648 | -122.480218609114 | (37.7168509964648, -122.480218609114) | ||||
| 150828 | 150828 | 69901 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 8 | 6002511.3219099995 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | ||
| 72252 | 72252 | 177954 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5989416.48515 | 2089561.1846099999 | 37.716927882190596 | -122.478558430025 | (37.7169278821906, -122.478558430025) | ||||
| 29240 | 29240 | 177953 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989426.93386 | 2089569.48868 | 37.7169512897353 | -122.47852292122101 | (37.7169512897353, -122.478522921221) | ||||
| 173771 | 173771 | 177853 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 737 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6000857.68516 | 2089577.3851 | 37.7176299901137 | -122.439013008468 | (37.7176299901137, -122.439013008468) | ||||
| 10545 | 10545 | 55314 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.5676900002 | 37.7182526888019 | -122.40305069543301 | (37.7182526888019, -122.403050695433) | |
| 146359 | 146359 | 177952 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989400.28977 | 2089605.00468 | 37.7170472609007 | -122.47861761173901 | (37.7170472609007, -122.478617611739) | ||||
| 175178 | 175178 | 55313 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 8 | 9x3 | Permit Number 11242 | 6011254.56702 | 2089617.4839 | 37.7183261795882 | -122.40307831540501 | (37.7183261795882, -122.403078315405) | |
| 61440 | 61440 | 177943 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Josepha Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5989687.380890001 | 2089641.08495 | 37.7171629928544 | -122.477627922194 | (37.7171629928544, -122.477627922194) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");