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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6830 | 6830 | 112118 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1816 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775883 | 5999532.43444 | 2115241.7678400003 | 37.7880226220009 | -122.445438140154 | (37.7880226220009, -122.445438140154) | |
| 6960 | 6960 | 18834 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2015 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005049.74421 | 2116112.8257400002 | 37.7907277467244 | -122.426411260094 | (37.7907277467244, -122.426411260094) | |||
| 6976 | 6976 | 9913 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1901X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6005586.32531 | 2116197.05094 | 37.7909893253357 | -122.424560708918 | (37.7909893253357, -122.424560708918) | |||
| 7014 | 7014 | 18833 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2011 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005074.81818 | 2116121.47161 | 37.7907529034619 | -122.42632512122499 | (37.7907529034619, -122.426325121225) | |||
| 7087 | 7087 | 17893 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2250 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3.5x3.5 | 6003147.3555 | 2115199.7182 | 37.7881128639093 | -122.43292815958901 | (37.7881128639093, -122.432928159589) | |||
| 7265 | 7265 | 11178 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.806291497706106 | -122.42056067914899 | (37.8062914977061, -122.420560679149) | |||
| 7276 | 7276 | 13053 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 551 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 07:36:00 AM | 3 | 3X3 | 6009716.4111 | 2120517.6505 | 37.8030850086189 | -122.410575951119 | (37.8030850086189, -122.410575951119) | ||
| 7277 | 7277 | 18945 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2820 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001293.28859 | 2115641.38083 | 37.789220219475204 | -122.439374566504 | (37.7892202194752, -122.439374566504) | |||
| 7401 | 7401 | 17978 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2566 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001667.0697 | 2115001.0109 | 37.7874831926794 | -122.43803544289601 | (37.7874831926794, -122.438035442896) | |||
| 7410 | 7410 | 17886 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2216 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003201.1119 | 2115208.837 | 37.788140950699 | -122.432742823561 | (37.788140950699, -122.432742823561) | |||
| 7417 | 7417 | 27383 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6006988.37342 | 2121139.78035 | 37.8046398981635 | -122.420060587734 | (37.8046398981635, -122.420060587734) | |||
| 7465 | 7465 | 18815 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1800X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006086.60229 | 2116306.71294 | 37.7913186696705 | -122.422837564717 | (37.7913186696705, -122.422837564717) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 7842 | 7842 | 17887 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2225 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2016 12:00:00 AM | 8 | 3x3 | 6003257.8293 | 2115161.3078 | 37.7880136640849 | -122.432543195006 | (37.7880136640849, -122.432543195006) | ||
| 7854 | 7854 | 13019 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 426 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 01:54:00 PM | 3 | 4X4 | 6010282.8242 | 2120633.0492 | 37.803433603680396 | -122.408624001449 | (37.8034336036804, -122.408624001449) | ||
| 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) | |||
| 8058 | 8058 | 13044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 532 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:51:00 AM | 3 | 3X3 | 6009787.8556 | 2120566.4846 | 37.803223100103295 | -122.41033216474399 | (37.8032231001033, -122.410332164744) | ||
| 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) | |||
| 8164 | 8164 | 17738 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 9 | 3X3 | 6002216.6 | 2113193.3325 | 37.7825510038819 | -122.43600478260001 | (37.7825510038819, -122.4360047826) | ||
| 8182 | 8182 | 18907 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2603 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/07/2011 12:00:00 AM | 3 | 1x1 | 6002308.81598 | 2115730.88168 | 37.7895237056151 | -122.435867376882 | (37.7895237056151, -122.435867376882) | ||
| 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) | |||
| 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) | |||
| 8572 | 8572 | 17914 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2334 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 7 | 3X3 | 6002756.0379 | 2115149.5391 | 37.7879528818401 | -122.43427846037201 | (37.7879528818401, -122.434278460372) | ||
| 8701 | 8701 | 18048 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2825 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 10:48:00 AM | 3 | 3X3 | 6000177.1728 | 2114733.4163 | 37.7866636055248 | -122.443170942274 | (37.7866636055248, -122.443170942274) | ||
| 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) | |||
| 8848 | 8848 | 18064 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1997 12:00:00 AM | 12 | 3X3 | 6000013.6639 | 2114768.6486 | 37.7867510196451 | -122.44373917398 | (37.7867510196451, -122.44373917398) | ||
| 8861 | 8861 | 17912 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2324 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1991 12:00:00 AM | 15 | 3X3 | 6002786.0192 | 2115147.8046 | 37.7879498210071 | -122.43417460656 | (37.7879498210071, -122.43417460656) | ||
| 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) | |||
| 8964 | 8964 | 115754 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3157 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772142 | 5999354.88302 | 2119687.6663900004 | 37.8002197429071 | -122.446372392773 | (37.8002197429071, -122.446372392773) | ||
| 8994 | 8994 | 19017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3150 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 01/19/2011 12:00:00 AM | 3 | 3X3 | Permit Number 767112 | 5999786.663369999 | 2115431.4160700003 | 37.7885578562165 | -122.444572191968 | (37.7885578562165, -122.444572191968) | |
| 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) | |||
| 9011 | 9011 | 18996 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3001 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2011 12:00:00 AM | 6 | 3x3 | 6000347.20569 | 2115461.97657 | 37.78867373653829 | -122.442635001919 | (37.7886737365383, -122.442635001919) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 9447 | 9447 | 17825 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1924 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2000 12:00:00 AM | 3 | 3X3 | 6004489.9176 | 2115389.1759 | 37.7887091248695 | -122.42829663448299 | (37.7887091248695, -122.428296634483) | ||
| 9786 | 9786 | 173690 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2015 12:00:00 AM | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | |||
| 9961 | 9961 | 54316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1324 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1972 12:00:00 AM | 5x5 | Permit Number 10077 | 5994279.15543647 | 2106492.16366383 | 37.7636972500787 | -122.46297836176001 | (37.7636972500787, -122.46297836176) | ||
| 10463 | 10463 | 37110 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.762145379104204 | -122.506126308526 | (37.7621453791042, -122.506126308526) |
| 10518 | 10518 | 820 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | ||
| 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) | |
| 10744 | 10744 | 15929 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997783.780180001 | 2086793.9366099997 | 37.7098118993789 | -122.44943761417 | (37.7098118993789, -122.44943761417) | ||
| 10746 | 10746 | 15961 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5873 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997080.5771 | 2086512.6894900003 | 37.7089994077614 | -122.451847724407 | (37.7089994077614, -122.451847724407) | ||
| 10913 | 10913 | 54811 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774552 | 6009584.74153 | 2095040.5771599999 | 37.7331234617736 | -122.409232703537 | (37.7331234617736, -122.409232703537) | |
| 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) | |||
| 11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
| 11312 | 11312 | 35280 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 11618 | 11618 | 15887 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5619 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5998592.6313 | 2087274.30395 | 37.71117711610329 | -122.44667662714501 | (37.7111771161033, -122.446676627145) | ||
| 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) | ||
| 11822 | 11822 | 117429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 418 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 777101 | 6000919.46363 | 2092339.69207 | 37.72521817457061 | -122.43899732339099 | (37.7252181745706, -122.438997323391) | ||
| 12051 | 12051 | 26281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1884 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2011 12:00:00 AM | 12 | 3x4 | 6000209.254369999 | 2093016.37684 | 37.7270357601912 | -122.441500974804 | (37.7270357601912, -122.441500974804) | ||
| 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) | ||
| 12318 | 12318 | 15707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4298 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2012 12:00:00 AM | 3 | 3x3 | 6003201.3472 | 2093656.0609099998 | 37.72896219882671 | -122.431203002635 | (37.7289621988267, -122.431203002635) | ||
| 12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
| 12388 | 12388 | 108548 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773712 | 6001628.81735 | 2093873.1155299998 | 37.7294689416254 | -122.436654875418 | (37.7294689416254, -122.436654875418) |
| 12410 | 12410 | 65623 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 185 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 18 | 3x3 | Permit Number 28530 | 6004571.295580001 | 2094064.8852900001 | 37.730162278453 | -122.426496085951 | (37.730162278453, -122.426496085951) |
| 12722 | 12722 | 117443 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 134 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778577 | 6004618.40487 | 2092601.87765 | 37.72614784693 | -122.42622910508601 | (37.72614784693, -122.426229105086) | ||
| 13138 | 13138 | 117433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 157 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776957 | 6000554.87359 | 2091671.7956400001 | 37.72336353237829 | -122.440209797466 | (37.7233635323783, -122.440209797466) | ||
| 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) | ||||
| 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) | ||||
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 13498 | 13498 | 60261 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.41226881345301 | (37.7575442102667, -122.412268813453) | |
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 13814 | 13814 | 10604 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.864569999 | 2095475.59177 | 37.73473117440221 | -122.383588632512 | (37.7347311744022, -122.383588632512) | ||
| 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) | |||
| 14191 | 14191 | 12216 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1523 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1992 12:00:00 AM | 15 | 3X3 | 6015935.5625 | 2095820.8342 | 37.735619647499 | -122.387330428498 | (37.735619647499, -122.387330428498) | ||
| 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) | |||
| 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) | |||
| 14969 | 14969 | 13320 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 16 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1992 12:00:00 AM | 6 | 3X3 | 6016446.48412 | 2095922.18028 | 37.7359262061134 | -122.385571020705 | (37.7359262061134, -122.385571020705) | ||
| 15185 | 15185 | 71390 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1530 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1988 12:00:00 AM | 1 | 3x3 | 6015584.85469 | 2096508.0059099998 | 37.7374870523836 | -122.38859092252599 | (37.7374870523836, -122.388590922526) | ||
| 15269 | 15269 | 39556 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013089.54039 | 2107025.61956 | 37.7662275503778 | -122.397956050431 | (37.7662275503778, -122.397956050431) | ||
| 16194 | 16194 | 85759 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1180 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009784.0631 | 2110452.1961 | 37.775451488302394 | -122.409630984869 | (37.7754514883024, -122.409630984869) | ||
| 16268 | 16268 | 13318 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 11 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1992 12:00:00 AM | 12 | 3X3 | 6016491.98013 | 2095896.26802 | 37.735857573458794 | -122.38541191625099 | (37.7358575734588, -122.385411916251) | ||
| 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) |
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");