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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7485 | 7485 | 18914 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2614 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6002119.347 | 2115753.8125400003 | 37.7895759031475 | -122.43652456008002 | (37.7895759031475, -122.43652456008) | |||
| 7573 | 7573 | 17799 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1847 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6005086.185 | 2115415.4042 | 37.788814862037796 | -122.42623550271799 | (37.7888148620378, -122.426235502718) | |||
| 7590 | 7590 | 17792 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1836 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005150.5923 | 2115481.6114 | 37.7890002907164 | -122.42601737732402 | (37.7890002907164, -122.426017377324) | |||
| 7633 | 7633 | 17741 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 6 | 3X3 | 6002204.1761 | 2113255.0755 | 37.7827198287143 | -122.436052183441 | (37.7827198287143, -122.436052183441) | |||
| 7672 | 7672 | 11164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424728999 | (37.8055622446775, -122.42024424729) | |||
| 7719 | 7719 | 19009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3087 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000046.25088 | 2115421.62879 | 37.788545791795 | -122.44367335825001 | (37.788545791795, -122.44367335825) | |||
| 7738 | 7738 | 6091 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2004 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000795.3066 | 2112440.8396 | 37.780404005029396 | -122.44086783303801 | (37.7804040050294, -122.440867833038) | |||
| 7754 | 7754 | 112345 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 12 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6002270.40051 | 2115593.91143 | 37.7891454381677 | -122.435990485098 | (37.7891454381677, -122.435990485098) | |||
| 7766 | 7766 | 18061 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2892 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000138.8729 | 2114783.4706 | 37.786798857700795 | -122.443307046821 | (37.7867988577008, -122.443307046821) | |||
| 7807 | 7807 | 11165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006893.18193 | 2121482.83945 | 37.8055764872155 | -122.42041437295 | (37.8055764872155, -122.42041437295) | |||
| 7863 | 7863 | 19013 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3109 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999823.86194 | 2115389.41015 | 37.78844464145371 | -122.44444047095502 | (37.7884446414537, -122.444440470955) | |||
| 8021 | 8021 | 18824 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1871 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005826.024569999 | 2116228.56745 | 37.7910893956089 | -122.423733599744 | (37.7910893956089, -122.423733599744) | |||
| 8024 | 8024 | 9728 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 629 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005789.7168 | 2111936.3952 | 37.779302101626705 | -122.423553936469 | (37.7793021016267, -122.423553936469) | |||
| 8045 | 8045 | 17795 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005085.8335 | 2115472.9124 | 37.7889727452829 | -122.426240814802 | (37.7889727452829, -122.426240814802) | |||
| 8117 | 8117 | 18842 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2101 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6004680.66603 | 2116061.68172 | 37.790566447935795 | -122.427684606568 | (37.7905664479358, -122.427684606568) | |||
| 8126 | 8126 | 2647 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1944 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004195.494 | 2115001.3607 | 37.7876276181393 | -122.42928763204901 | (37.7876276181393, -122.429287632049) | |||
| 8161 | 8161 | 18934 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2715 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001626.08114 | 2115640.1055400004 | 37.789235650952 | -122.438223055655 | (37.789235650952, -122.438223055655) | |||
| 8184 | 8184 | 117421 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 27 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996647.4398 | 2112726.9752 | 37.7809525538521 | -122.45523784550699 | (37.7809525538521, -122.455237845507) | |||
| 8213 | 8213 | 18826 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6005641.1205400005 | 2116203.30526 | 37.791009592476 | -122.42437156440599 | (37.791009592476, -122.424371564406) | |||
| 8314 | 8314 | 17796 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005069.2088 | 2115468.6596 | 37.7889601284654 | -122.42629803117799 | (37.7889601284654, -122.426298031178) | |||
| 8344 | 8344 | 8692 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2955 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997893.1705 | 2113031.5548 | 37.781860243466 | -122.450950238487 | (37.781860243466, -122.450950238487) | |||
| 8419 | 8419 | 17793 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1843 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005105.442000001 | 2115417.7383 | 37.7888223593362 | -122.426169042396 | (37.7888223593362, -122.426169042396) | |||
| 8427 | 8427 | 19039 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3241 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999284.05701 | 2115314.75606 | 37.7882088464099 | -122.44630273130801 | (37.7882088464099, -122.446302731308) | |||
| 8437 | 8437 | 96380 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 553 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005168.9792 | 2111274.1780000003 | 37.7774487586726 | -122.42565418286301 | (37.7774487586726, -122.425654182863) | |||
| 8473 | 8473 | 19015 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3135 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 5999785.512569999 | 2115383.13203 | 37.7884252151982 | -122.444572701871 | (37.7884252151982, -122.444572701871) | |||
| 8511 | 8511 | 11154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006919.78752 | 2121256.3248099997 | 37.804956035058495 | -122.420306213261 | (37.8049560350585, -122.420306213261) | |||
| 8736 | 8736 | 11158 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2626 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006955.38483 | 2121356.90745 | 37.8052342151411 | -122.42019016746599 | (37.8052342151411, -122.420190167466) | |||
| 8792 | 8792 | 11170 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | |||
| 8846 | 8846 | 18825 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1875 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005783.22199 | 2116219.7593799997 | 37.7910627945724 | -122.42388106877199 | (37.7910627945724, -122.423881068772) | |||
| 8886 | 8886 | 18912 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2610 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002161.87395 | 2115762.44795 | 37.789602030260205 | -122.436378039822 | (37.7896020302602, -122.436378039822) | |||
| 8910 | 8910 | 18818 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1846 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005917.03781 | 2116283.90197 | 37.7912464676084 | -122.423422632158 | (37.7912464676084, -122.423422632158) | |||
| 9009 | 9009 | 11172 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.80615118099271 | -122.42055467348301 | (37.8061511809927, -122.420554673483) | |||
| 9062 | 9062 | 17891 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x9 | 6003186.0915 | 2115153.6856 | 37.7879886670873 | -122.43279085011999 | (37.7879886670873, -122.43279085012) | |||
| 9077 | 9077 | 18066 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999965.0708 | 2114761.4253 | 37.786728414639505 | -122.443906774886 | (37.7867284146395, -122.443906774886) | |||
| 9087 | 9087 | 11163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | |||
| 9132 | 9132 | 11160 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | |||
| 9180 | 9180 | 9916 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1990X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005305.17759 | 2116200.067 | 37.790981725181 | -122.42553368453301 | (37.790981725181, -122.425533684533) | |||
| 9210 | 9210 | 11156 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006962.612869999 | 2121312.5054900004 | 37.80511270594771 | -122.420162000697 | (37.8051127059477, -122.420162000697) | |||
| 9242 | 9242 | 17892 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2249 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003165.9152 | 2115151.8922 | 37.7879825985405 | -122.43286052828002 | (37.7879825985405, -122.43286052828) | |||
| 9243 | 9243 | 17977 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2558 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001719.5728 | 2115004.5111 | 37.7874957889991 | -122.43785404394698 | (37.7874957889991, -122.437854043947) | |||
| 9279 | 9279 | 19768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 9303 | 9303 | 11157 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | |||
| 9309 | 9309 | 17899 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2279 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003065.4822 | 2115140.6832 | 37.787946124669 | -122.433207206924 | (37.787946124669, -122.433207206924) | |||
| 9323 | 9323 | 18065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999986.084 | 2114760.7686 | 37.786727810113504 | -122.443834027246 | (37.7867278101135, -122.443834027246) | |||
| 9363 | 9363 | 18821 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6005936.5128 | 2116239.67488 | 37.79112613022821 | -122.423352103743 | (37.7911261302282, -122.423352103743) | |||
| 9421 | 9421 | 18820 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005909.66344 | 2116240.6882700003 | 37.7911273973734 | -122.42344507383899 | (37.7911273973734, -122.423445073839) | |||
| 9537 | 9537 | 137839 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005239.1389 | 2115489.1761 | 37.7890260654428 | -122.425711556168 | (37.7890260654428, -122.425711556168) | ||||
| 10809 | 10809 | 15867 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5425 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5 | 5999480.671080001 | 2088101.53675 | 37.713499198913105 | -122.443666741949 | (37.7134991989131, -122.443666741949) | |||
| 11103 | 11103 | 117183 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6004102.13214 | 2092696.8683900002 | 37.7263794754103 | -122.42802059686899 | (37.7263794754103, -122.428020596869) | |||
| 12551 | 12551 | 19769 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 12682 | 12682 | 19875 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 13009 | 13009 | 115969 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1599x 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 2 | 3x3 | 5986813.3885 | 2104627.15 | 37.7581435700771 | -122.488662699732 | (37.7581435700771, -122.488662699732) | |||
| 13255 | 13255 | 187618 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993007.0 | 2088191.0 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | ||||
| 13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13335 | 13335 | 187678 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13336 | 13336 | 187675 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13337 | 13337 | 187679 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13525 | 13525 | 3697 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016390.489709999 | 2099364.7540700003 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | |||
| 13578 | 13578 | 187698 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | ||||
| 14026 | 14026 | 17630 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10M | ||||||||
| 14134 | 14134 | 104461 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011834.442419999 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | |||
| 14564 | 14564 | 22518 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6518 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6012926.62983 | 2089906.00338 | 37.719211629596295 | -122.39731887985799 | (37.7192116295963, -122.397318879858) | |||
| 14614 | 14614 | 22513 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | |||
| 14876 | 14876 | 96731 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1504 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015860.59929 | 2096653.48415 | 37.7379017837359 | -122.38764768211 | (37.7379017837359, -122.38764768211) | |||
| 15055 | 15055 | 113527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408001 | (37.7659290977746, -122.39792893408) | ||||
| 15839 | 15839 | 18557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1700X Quesada Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014589.42489 | 2095117.7447900001 | 37.733614463738604 | -122.391935430178 | (37.7336144637386, -122.391935430178) | |||
| 16013 | 16013 | 22114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3650X 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5X5 | 6015872.240569999 | 2098764.87252 | 37.7436998694469 | -122.38775470773999 | (37.7436998694469, -122.38775470774) | |||
| 16074 | 16074 | 22377 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014067.3893 | 2092832.2588 | 37.7273099879691 | -122.393580370471 | (37.7273099879691, -122.393580370471) | |||
| 16190 | 16190 | 22512 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | |||
| 16349 | 16349 | 22459 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6150 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6013537.9663 | 2091442.0718 | 37.723463383403704 | -122.395313253548 | (37.7234633834037, -122.395313253548) | |||
| 16362 | 16362 | 22376 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.39354686543601 | (37.7273687774645, -122.393546865436) | |||
| 16403 | 16403 | 3726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016987.22702 | 2098921.28419 | 37.744191044988 | -122.38391020401899 | (37.744191044988, -122.383910204019) | |||
| 16532 | 16532 | 22198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4049 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6015622.4674 | 2097608.2349 | 37.740510141063204 | -122.38853765218501 | (37.7405101410632, -122.388537652185) | |||
| 16594 | 16594 | 22437 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | |||
| 16706 | 16706 | 102011 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 469 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6014033.25215 | 2112677.25893 | 37.7817981973592 | -122.395087809375 | (37.7817981973592, -122.395087809375) | |||
| 16775 | 16775 | 110930 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | ||||
| 16824 | 16824 | 22511 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013025.9659 | 2090108.3639200001 | 37.719772801157 | -122.396989691115 | (37.719772801157, -122.396989691115) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 17981 | 17981 | 17200 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006498.358440001 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | |||
| 18405 | 18405 | 11168 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18674 | 18674 | 29222 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 18831 | 18831 | 4449 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004544.3142800005 | 2100922.31022 | 37.748989683529 | -122.427077601077 | (37.748989683529, -122.427077601077) | |||
| 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) | |||
| 19951 | 19951 | 4423 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1145 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004475.83751 | 2102212.10827 | 37.7525272963192 | -122.42740626460301 | (37.7525272963192, -122.427406264603) | |||
| 20047 | 20047 | 4438 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004526.51906 | 2101259.5658 | 37.749914702805206 | -122.42716315625401 | (37.7499147028052, -122.427163156254) | |||
| 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) | |||
| 20963 | 20963 | 10267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | 6004928.575180001 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 22374 | 22374 | 9065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) |
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");