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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |
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) | |||
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) | |
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) | ||
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) | |
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
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) | |||
178210 | 178210 | 131969 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 851 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006677.695040001 | 2121126.15503 | 37.8045849774818 | -122.421134754189 | (37.8045849774818, -122.421134754189) | |||
164998 | 164998 | 131977 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006939.66752 | 2121114.4281599997 | 37.804567543218 | -122.42022733912901 | (37.804567543218, -122.420227339129) | |||
171937 | 171937 | 131978 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006942.77558 | 2121093.1893700003 | 37.8045094020391 | -122.420215075084 | (37.8045094020391, -122.420215075084) | |||
56443 | 56443 | 131979 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006943.6735 | 2121075.27291 | 37.8044602585979 | -122.420210695394 | (37.8044602585979, -122.420210695394) | |||
32090 | 32090 | 131980 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006950.58761 | 2121054.46009 | 37.804403501475 | -122.420185290441 | (37.804403501475, -122.420185290441) | |||
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) | |
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) | |||
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) | |||
50329 | 50329 | 34243 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 281 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1999 12:00:00 AM | 6 | Permit Number 41308 | 6010484.3701 | 2120961.6992 | 37.8043472811285 | -122.40794973039101 | (37.8043472811285, -122.407949730391) | ||
164390 | 164390 | 131981 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006953.1951 | 2121033.48378 | 37.8043460527886 | -122.420174777362 | (37.8043460527886, -122.420174777362) | |||
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) | |||
183300 | 183300 | 131982 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2553 Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006953.2822900005 | 2121013.06293 | 37.8042899872466 | -122.420173025464 | (37.8042899872466, -122.420173025464) |
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");