Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1557 | 1557 | 251590 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340x Vicente St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991910.0 | 2097743.0 | 37.739537567792894 | -122.47053520105601 | (37.7395375677929, -122.470535201056) | ||||
11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
28601 | 28601 | 232469 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6003464.52997 | 2095634.55653 | 37.7344096119087 | -122.43043426935301 | (37.7344096119087, -122.430434269353) | ||||
32896 | 32896 | 232460 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6003616.28584 | 2095734.4889200001 | 37.734692598886 | -122.429916725697 | (37.734692598886, -122.429916725697) | ||||
34673 | 34673 | 232461 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.42992861471501 | (37.7346701778724, -122.429928614715) | ||||
36474 | 36474 | 232464 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003586.39232 | 2095695.85827 | 37.7345848349269 | -122.430017322941 | (37.7345848349269, -122.430017322941) | ||||
37321 | 37321 | 194134 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015354.20873 | 2102436.4215599997 | 37.753752465207704 | -122.389802351607 | (37.7537524652077, -122.389802351607) | ||||
45233 | 45233 | 194145 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014334.84146 | 2106266.74633 | 37.764213127454205 | -122.393595642523 | (37.7642131274542, -122.393595642523) | ||||
48789 | 48789 | 194147 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014318.41099 | 2106520.5018700003 | 37.7649089715932 | -122.393670233204 | (37.7649089715932, -122.393670233204) | ||||
49287 | 49287 | 232462 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6003605.59401 | 2095716.2711599998 | 37.734641971550396 | -122.42995239189501 | (37.7346419715504, -122.429952391895) | ||||
55984 | 55984 | 194132 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 46 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015356.8182 | 2102444.39788 | 37.7537745112003 | -122.389793884481 | (37.7537745112003, -122.389793884481) | ||||
57533 | 57533 | 194133 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015360.93697 | 2102437.8741900004 | 37.7537568269303 | -122.38977918508199 | (37.7537568269303, -122.389779185082) | ||||
57628 | 57628 | 131858 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2120 Jefferson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5999033.9151099995 | 2121159.67967 | 37.804243156854895 | -122.447589082867 | (37.8042431568549, -122.447589082867) | ||||
61669 | 61669 | 232458 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1201 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004370.47722 | 2095993.8986799999 | 37.735447561742795 | -122.427327701639 | (37.7354475617428, -122.427327701639) | ||||
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) | ||
65224 | 65224 | 194135 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015359.62578 | 2102424.0826 | 37.753718885432704 | -122.38978275627 | (37.7537188854327, -122.38978275627) | ||||
68866 | 68866 | 232463 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003597.18569 | 2095706.1719400003 | 37.7346137651955 | -122.42998074211701 | (37.7346137651955, -122.429980742117) | ||||
71061 | 71061 | 246756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1838 Alabama St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009319.49474 | 2098935.33423 | 37.7438027564037 | -122.410424651497 | (37.7438027564037, -122.410424651497) | ||||
71773 | 71773 | 194149 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014236.41284 | 2106693.2411599997 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | ||||
73060 | 73060 | 233748 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 190 Storrie St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6000735.315330001 | 2105275.64227 | 37.7607267499572 | -122.440561303781 | (37.7607267499572, -122.440561303781) | |||
81004 | 81004 | 70844 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/19/2015 12:00:00 AM | 3 | Permit Number 774723 | 6001345.45815513 | 2095262.03450684 | 37.733266486381396 | -122.437733908358 | (37.7332664863814, -122.437733908358) | ||
96949 | 96949 | 109968 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
99354 | 99354 | 102249 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
101894 | 101894 | 102250 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
104754 | 104754 | 102248 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
113628 | 113628 | 116851 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
115729 | 115729 | 105234 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 250 STATES ST | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6000595.6 | 2106681.2 | 37.7645781078798 | -122.441145360444 | (37.7645781078798, -122.441145360444) | ||||
117231 | 117231 | 116850 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
123831 | 123831 | 232470 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 63 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 5ft | 6003561.98483 | 2095678.7252200001 | 37.734536409124395 | -122.43010048596399 | (37.7345364091244, -122.430100485964) | |||
129649 | 129649 | 232457 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1201 San Jose Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004298.74095 | 2095904.57797 | 37.7351982498932 | -122.427569359364 | (37.7351982498932, -122.427569359364) | ||||
137689 | 137689 | 131828 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3590 Washington St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5997591.7646699995 | 2115789.4981299997 | 37.7894155666343 | -122.452192015462 | (37.7894155666343, -122.452192015462) | ||||
140856 | 140856 | 109967 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1019 Hollister Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | ||
153006 | 153006 | 194148 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014289.98871 | 2106632.9609 | 37.7652161800146 | -122.393776411647 | (37.7652161800146, -122.393776411647) | ||||
153941 | 153941 | 194136 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 51 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015363.679269999 | 2102425.5673 | 37.753723186885296 | -122.389768841963 | (37.7537231868853, -122.389768841963) | ||||
157055 | 157055 | 247964 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 14 Joy St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010353.4746900005 | 2098911.2198799998 | 37.7437944538423 | -122.40684767629601 | (37.7437944538423, -122.406847676296) | ||||
157894 | 157894 | 233787 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 250 States St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6000617.13444 | 2106653.31967 | 37.764502781988604 | -122.44106887843901 | (37.7645027819886, -122.441068878439) | |||
158562 | 158562 | 232465 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6003573.73733 | 2095685.05632 | 37.7345544585066 | -122.430060305156 | (37.7345544585066, -122.430060305156) | ||||
166020 | 166020 | 99921 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1740 Jones St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | ||||
166955 | 166955 | 194146 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 101 Pennsylvania Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014326.39851 | 2106410.8143 | 37.7646082374101 | -122.393634928533 | (37.7646082374101, -122.393634928533) | ||||
167809 | 167809 | 232467 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003496.7451 | 2095646.5964799998 | 37.7344444957064 | -122.43032374986299 | (37.7344444957064, -122.430323749863) | ||||
168837 | 168837 | 131859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2120 Jefferson St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5999029.48061 | 2121159.2823099997 | 37.8042418123825 | -122.44760440011801 | (37.8042418123825, -122.447604400118) | ||||
168934 | 168934 | 232466 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003503.44574 | 2095655.81053 | 37.7344701749411 | -122.430301240716 | (37.7344701749411, -122.430301240716) | ||||
176093 | 176093 | 247041 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 595 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002155.11446 | 2099145.78965 | 37.7439763821952 | -122.43521240422501 | (37.7439763821952, -122.435212404225) | ||||
178109 | 178109 | 194137 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1301 Minnesota St | 52 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015362.68251 | 2102417.32718 | 37.7537005059858 | -122.389771713504 | (37.7537005059858, -122.389771713504) | ||||
179976 | 179976 | 232468 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6003479.361880001 | 2095639.31415 | 37.7344235154206 | -122.43038332994101 | (37.7344235154206, -122.430383329941) | ||||
182150 | 182150 | 232459 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1201 San Jose Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004401.596369999 | 2096010.3452700002 | 37.7354944802799 | -122.427221282156 | (37.7354944802799, -122.427221282156) | ||||
182460 | 182460 | 132019 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1116 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6007503.17736 | 2119909.69915 | 37.80129139754929 | -122.41819179113001 | (37.8012913975493, -122.41819179113) | ||||
185030 | 185030 | 108987 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3560 Baker St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999200.334980001 | 2121108.96976 | 37.804113430551894 | -122.447009524696 | (37.8041134305519, -122.447009524696) |
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");