Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149795 | 149795 | 131874 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 295 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6002038.91196 | 2121849.60525 | 37.806308784479796 | -122.43723950400299 | (37.8063087844798, -122.437239504003) | |||
| 150189 | 150189 | 131962 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2753 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006843.619030001 | 2121816.35124 | 37.806489432203996 | -122.420609582486 | (37.806489432204, -122.420609582486) | |||
| 121242 | 121242 | 131963 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2753 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006844.59432 | 2121791.39678 | 37.806420968609295 | -122.420604434741 | (37.8064209686093, -122.420604434741) | |||
| 81923 | 81923 | 11183 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | ||
| 97969 | 97969 | 11184 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | |||
| 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) | |||
| 151730 | 151730 | 131873 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001088.519780001 | 2121715.49846 | 37.8058864916338 | -122.44051886926901 | (37.8058864916338, -122.440518869269) | ||||
| 41990 | 41990 | 131872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6000857.63079 | 2121697.12511 | 37.805822893385 | -122.441316575098 | (37.805822893385, -122.441316575098) | |||
| 46684 | 46684 | 131871 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6000836.15896 | 2121693.63297 | 37.8058120817332 | -122.441390630693 | (37.8058120817332, -122.441390630693) | |||
| 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) | |||
| 6289 | 6289 | 11171 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.805969514352604 | -122.420334179488 | (37.8059695143526, -122.420334179488) | |||
| 51465 | 51465 | 131866 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 555 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000334.74544 | 2121624.79375 | 37.805594490755 | -122.443120895728 | (37.805594490755, -122.443120895728) | |||
| 29360 | 29360 | 131865 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 555 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6000313.878190001 | 2121622.81545 | 37.8055878690403 | -122.443192967399 | (37.8055878690403, -122.443192967399) | |||
| 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) | |||
| 126649 | 126649 | 11174 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | |||
| 5888 | 5888 | 11169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | |||
| 159818 | 159818 | 131875 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1445 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002295.777919999 | 2121559.23288 | 37.8055260973233 | -122.43632978131001 | (37.8055260973233, -122.43632978131) | |||
| 6941 | 6941 | 87735 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.063999999 | 2121526.81323 | 37.8056161950061 | -122.42538739630501 | (37.8056161950061, -122.425387396305) | ||
| 137629 | 137629 | 87887 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3750 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002559.44866 | 2121515.2507 | 37.8054203118567 | -122.435414165341 | (37.8054203118567, -122.435414165341) | |
| 28236 | 28236 | 87886 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.805375884443606 | -122.4354036226 | (37.8053758844436, -122.4354036226) | |
| 133497 | 133497 | 131968 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2654 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006939.68178 | 2121495.98775 | 37.805615209341 | -122.420254387139 | (37.805615209341, -122.420254387139) | |||
| 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) | |||
| 119836 | 119836 | 87885 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3750 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002564.08274 | 2121481.52987 | 37.8053279865497 | -122.435395714839 | (37.8053279865497, -122.435395714839) | |
| 58606 | 58606 | 112712 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 416 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008783.11467 | 2121477.20046 | 37.805667324157795 | -122.413873574 | (37.8056673241578, -122.413873574) | |||
| 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) | |||
| 31954 | 31954 | 112713 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 416 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008763.59145 | 2121474.42141 | 37.80565859714 | -122.41394094043999 | (37.80565859714, -122.41394094044) | |||
| 62303 | 62303 | 96895 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 777 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3.5x6 | 5999259.60924 | 2121474.0236299997 | 37.8051191558782 | -122.44683068639 | (37.8051191558782, -122.44683068639) | |||
| 35001 | 35001 | 112714 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 416 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6008746.75593 | 2121471.08922 | 37.805648502252204 | -122.41399896650499 | (37.8056485022522, -122.413998966505) | |||
| 56556 | 56556 | 87733 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.4175299997 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | ||
| 158860 | 158860 | 96896 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 777 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3.5x6 | 5999265.807709999 | 2121460.8437099997 | 37.8050833214902 | -122.446808286977 | (37.8050833214902, -122.446808286977) | |||
| 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) | ||
| 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) | |||
| 6990 | 6990 | 11166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006897.54428 | 2121449.5194099997 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | |||
| 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) | |||
| 5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
| 160376 | 160376 | 131864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 801 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999091.87418 | 2121434.80116 | 37.80500187798479 | -122.447408326338 | (37.8050018779848, -122.447408326338) | ||||
| 3589 | 3589 | 11167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.42039071266501 | (37.805442070952, -122.420390712665) | |||
| 35643 | 35643 | 131967 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2642 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6006948.59932 | 2121422.85954 | 37.805414920417796 | -122.420218333313 | (37.8054149204178, -122.420218333313) | |||
| 1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 142500 | 142500 | 11162 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2640 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006953.557207401 | 2121387.1992738997 | 37.8053172857834 | -122.420198643397 | (37.8053172857834, -122.420198643397) | |||
| 48986 | 48986 | 131800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3646 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999162.81759 | 2121382.5362400003 | 37.8048624264288 | -122.44715905583901 | (37.8048624264288, -122.447159055839) | |||
| 103231 | 103231 | 11161 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006954.2638733005 | 2121382.2190943 | 37.805303651298296 | -122.420195844212 | (37.8053036512983, -122.420195844212) | |||
| 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) | |||
| 187485 | 187485 | 55910 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3646 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1973 12:00:00 AM | 7 | Permit Number 11968 | 5999164.92629 | 2121362.0715400004 | 37.8048063563971 | -122.447150284777 | (37.8048063563971, -122.447150284777) | ||
| 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) | |||
| 167103 | 167103 | 41206 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3720 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 8 | Permit Number 41913 | 5999654.61261 | 2121348.57822 | 37.804797274147504 | -122.445454709292 | (37.8047972741475, -122.445454709292) | |
| 6828 | 6828 | 11159 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | |||
| 87352 | 87352 | 87731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 88228 | 88228 | 87736 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 113968 | 113968 | 87734 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | |||
| 125002 | 125002 | 87737 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 61461 | 61461 | 131966 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2618 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6006960.066430001 | 2121331.19961 | 37.80516389175521 | -122.42017214053301 | (37.8051638917552, -122.420172140533) | |||
| 189127 | 189127 | 131863 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | |||
| 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) | |||
| 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) | |||
| 30412 | 30412 | 131862 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5998877.1278 | 2121309.5311 | 37.8046456466411 | -122.448142451907 | (37.8046456466411, -122.448142451907) | |||
| 74510 | 74510 | 131861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 5998876.901959999 | 2121298.6839099997 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | |||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 136039 | 136039 | 131799 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999175.50089 | 2121283.38035 | 37.8045908959147 | -122.447108023813 | (37.8045908959147, -122.447108023813) | |||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 58493 | 58493 | 131965 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2616 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006966.563490001 | 2121270.91846 | 37.8049987411622 | -122.42014537582399 | (37.8049987411622, -122.420145375824) | |||
| 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) | |||
| 27582 | 27582 | 131964 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2616 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6006972.364130001 | 2121248.27564 | 37.8049368965806 | -122.42012369407699 | (37.8049368965806, -122.420123694077) | |||
| 93301 | 93301 | 1757 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2606 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 121514 | 121514 | 1758 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2606 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 128056 | 128056 | 1759 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2606X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 151821 | 151821 | 131847 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 5999134.00853 | 2121203.2067400003 | 37.804368390155204 | -122.44724583773399 | (37.8043683901552, -122.447245837734) | |||
| 74237 | 74237 | 131849 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5999142.98862 | 2121202.5970099997 | 37.804367229113396 | -122.447214717591 | (37.8043672291134, -122.447214717591) | |||
| 47219 | 47219 | 103501 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2050 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768855 | 5999398.93831 | 2121201.05628 | 37.804377619899995 | -122.446328874603 | (37.8043776199, -122.446328874603) | |
| 66273 | 66273 | 131860 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2050 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999372.26624 | 2121195.48978 | 37.804360812456295 | -122.44642077450399 | (37.8043608124563, -122.446420774504) | |||
| 50235 | 50235 | 131850 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5999143.57978 | 2121190.63067 | 37.8043344065648 | -122.447211810097 | (37.8043344065648, -122.447211810097) | |||
| 59477 | 59477 | 131848 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5999135.0033599995 | 2121188.05982 | 37.804326857662 | -122.44724130424801 | (37.804326857662, -122.447241304248) | |||
| 77501 | 77501 | 88001 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 81690 | 81690 | 88000 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 101107 | 101107 | 88002 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 104248 | 104248 | 87999 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 143077 | 143077 | 87998 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952.0 | 2121180.0 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | ||
| 99823 | 99823 | 11150 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 101063 | 101063 | 11148 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 103862 | 103862 | 11145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 113524 | 113524 | 11152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 120483 | 120483 | 11149 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 128539 | 128539 | 11146 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 138383 | 138383 | 11151 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 140009 | 140009 | 11147 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
| 186863 | 186863 | 131851 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5999147.80126 | 2121174.2853 | 37.8042897678153 | -122.447196024289 | (37.8042897678153, -122.447196024289) | |||
| 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) | ||||
| 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) | ||||
| 170888 | 170888 | 131971 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 851 Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006836.95388 | 2121150.13157 | 37.8046597875834 | -122.420585325955 | (37.8046597875834, -122.420585325955) | |||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 172376 | 172376 | 131812 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999306.86195 | 2121143.68392 | 37.8042148317993 | -122.446643381002 | (37.8042148317993, -122.446643381002) | |||
| 150572 | 150572 | 131811 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999294.880469999 | 2121141.75574 | 37.8042088531305 | -122.446684704858 | (37.8042088531305, -122.446684704858) | |||
| 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) | |||
| 69912 | 69912 | 131810 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999265.047 | 2121138.69197 | 37.8041987366312 | -122.44678772488399 | (37.8041987366312, -122.446787724884) | |||
| 181854 | 181854 | 131970 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 851 Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006761.3651 | 2121137.86846 | 37.8046218559624 | -122.420846037638 | (37.8046218559624, -122.420846037638) | |||
| 67220 | 67220 | 131809 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999252.2284 | 2121136.94892 | 37.8041932184065 | -122.446831958955 | (37.8041932184065, -122.446831958955) | |||
| 169274 | 169274 | 131808 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999238.71289 | 2121134.04779 | 37.804184480577604 | -122.446878521336 | (37.8041844805776, -122.446878521336) | |||
| 63472 | 63472 | 131807 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2099 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999225.2356900005 | 2121132.98826 | 37.804180801454 | -122.446925083734 | (37.804180801454, -122.446925083734) |
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");