trees
2,306 rows where qSpecies_id = 15 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66713 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 612 WISCONSIN ST | 1 | Back Yard : Yard | Tree | Private 2 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.399296223309 | (37.7594155491308, -122.399296223309) | 10 | 3 | 8 | 28856 | 29 | |||||
24524 | 107157 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301X Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 28 | 6007313 | 2098782 | 37.7432690474632 | -122.417351790512 | (37.7432690474632, -122.417351790512) | 2 | 7 | 7 | 28859 | 2 | ||||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
150077 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
23834 | 107210 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 603 PERALTA AVE | 1 | unknown : Yard | Tree | Private 2 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.408607810015 | (37.7431547125392, -122.408607810015) | 10 | 7 | 7 | 28859 | 2 | ||||
37858 | 107319 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 530X JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | DPW 1 | 27 | 5991365.2 | 2093720 | 37.728459908419 | -122.472125702067 | (37.728459908419, -122.472125702067) | 9 | 8 | 4 | 64 | 40 | ||||
62630 | 107496 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 846x JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | Private 2 | 60 | 5991242 | 2091754 | 37.7230546314384 | -122.472408341718 | (37.7230546314384, -122.472408341718) | 9 | 8 | 4 | 64 | 40 | ||||
166327 | 107497 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 826 JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | DPW 1 | 36 | 5991253.8 | 2091935.2 | 37.7235528447013 | -122.472380755006 | (37.7235528447013, -122.472380755006) | 9 | 8 | 4 | 64 | 40 | ||||
142853 | 107503 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4140 19th Ave | Back Yard : Yard | Tree | Private 2 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | 9 | 8 | 6 | 64 | 24 | ||||||
23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
90322 | 107542 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 5 | Back Yard : Yard | Tree | Private 2 | 40 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
84037 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470x Broadway | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669829 | (37.7982025127238, -122.40501669829) | 3 | 1 | 10 | 308 | 23 | ||||
78837 | 107619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51X Prentiss St | 3 | Back Yard : Yard | Tree | DPW 1 | 12 | 6008906.75623 | 2098323.8391 | 37.7421005785929 | -122.411808608798 | (37.7421005785929, -122.411808608798) | 10 | 7 | 7 | 28859 | 2 | ||||
115926 | 107644 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1400x KIRKWOOD AVE | 1 | Median : Yard | Tree | Private 2 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811874 | (37.7371023539668, -122.38775811874) | 10 | 3 | 8 | 58 | 1 | |||||
116374 | 107662 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X GATES ST | 2 | Front Yard : Yard | Tree | DPW 1 | 6008333 | 2098264 | 37.7419040691052 | -122.413788251876 | (37.7419040691052, -122.413788251876) | 2 | 7 | 7 | 28859 | 2 | |||||
168147 | 107817 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X BROTHERHOOD WAY | unknown : Yard | Tree | DPW 1 | 5991892 | 2087849 | 37.7123700531512 | -122.469877266524 | (37.7123700531512, -122.469877266524) | 9 | 8 | 4 | 64 | 24 | ||||||
76023 | 107819 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 75X RALSTON ST | Back Yard : Yard | Tree | Private 2 | 45 | Permit Number 775492 | 5992193 | 2088303 | 37.7136340221674 | -122.468869945866 | (37.7136340221674, -122.468869945866) | 9 | 8 | 6 | 64 | 24 | ||||
38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
144075 | 108043 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 1 | Median : Yard | Tree | DPW 1 | 30 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
26583 | 108044 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard | Tree | DPW 1 | 99 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
120831 | 108045 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 3 | Median : Yard | Tree | DPW 1 | 40 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
178133 | 108046 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard | Tree | DPW 1 | 99 | 5985273 | 2095807 | 37.7338358213683 | -122.493340136435 | (37.7338358213683, -122.493340136435) | 1 | 8 | 4 | 64 | 35 | ||||
178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
132961 | 108177 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 201 PANORAMA DR | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 3x3 | 5997273.1 | 2100946.6 | 37.7486425219839 | -122.452223122411 | (37.7486425219839, -122.452223122411) | 1 | 5 | 4 | 63 | 38 | |||
168614 | 108208 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 100X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000799.34617 | 2109469.60329 | 37.7722459721119 | -122.440640678445 | (37.7722459721119, -122.440640678445) | 15 | 5 | 11 | 29492 | 9 | |||||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
76707 | 108352 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1501x RIVERA ST | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
97625 | 108362 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5290 DIAMOND HEIGHTS BLVD | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | ||||
172239 | 108363 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5290 DIAMOND HEIGHTS BLVD | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | ||||
172409 | 108364 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5290 DIAMOND HEIGHTS BLVD | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | ||||
74302 | 108365 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5290 DIAMOND HEIGHTS BLVD | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/23/2016 12:00:00 AM | 3 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | ||
145051 | 108367 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 36 KNOLLVIEW WAY | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 774549 | 5997629 | 2101321 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | 1 | 5 | 4 | 63 | 38 | |||
122326 | 108368 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 36 KNOLLVIEW WAY | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 774549 | 5997629 | 2101321 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | 1 | 5 | 4 | 63 | 38 | |||
170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
39842 | 108688 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x MONTEZUMA ST | 1 | Median : Yard | Tree | DPW 1 | 20 | 6007361 | 2099793 | 37.7460477277002 | -122.417257445993 | (37.7460477277002, -122.417257445993) | 2 | 7 | 7 | 28859 | 2 | ||||
53506 | 108816 | Private 9 | Pinus radiata :: Monterey Pine 15 | 348 Gold Mine Dr | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 6001084 | 2097744 | 37.740066514789 | -122.438815634293 | (37.740066514789, -122.438815634293) | 2 | 7 | 5 | 63 | 7 | ||||
128716 | 108973 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3485X SAN BRUNO AVE | 1 | Median : Yard | Tree | DPW for City Agency 14 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
149707 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 MIGUEL ST | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6003334.2 | 2097391.9 | 37.7392274919289 | -122.431010244874 | (37.7392274919289, -122.431010244874) | 2 | 7 | 5 | 63 | 7 | ||||
35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
98353 | 109309 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 349x MAYFLOWER ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6009941 | 2098430 | 37.7424500403346 | -122.408239989358 | (37.7424500403346, -122.408239989358) | 10 | 7 | 7 | 28859 | 2 | |||||
164196 | 109628 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 483X LAKESHORE DR | 21 | Median : Cutout | Tree | DPW 1 | 02/27/2015 10:16:00 AM | 3 | 30x200 | 5984884 | 2095569 | 37.7331595755245 | -122.494667466163 | (37.7331595755245, -122.494667466163) | 1 | 8 | 4 | 64 | 35 | ||
21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
166973 | 109639 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X Geneva Ave | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
138617 | 109640 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X Geneva Ave | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
75230 | 109961 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 115x GARCES DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | |||
129931 | 109962 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 121x GARCES DR | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770873 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | |
106712 | 109965 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 123x GARCES DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
180499 | 110077 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4099x ALEMANY BLVD | Median : Cutout | Tree | Private 2 | 48 | 5991599 | 2086829 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | 9 | 8 | 4 | 64 | 24 | |||||
8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
32419 | 110166 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 131x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
78402 | 110167 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 131x GARCES DR | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 770873 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||
34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
101814 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1860 09TH AVE | 2 | Front Yard : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494 | 2102835 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | 1 | 8 | 4 | 56 | 12 | ||
129929 | 110447 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1400 Holloway Ave | 1 | Median : Cutout | Tree | Private 2 | 5x5 | 5991161.796471 | 2091241.0154845 | 37.7216414605593 | -122.472648202858 | (37.7216414605593, -122.472648202858) | 9 | 8 | 4 | 64 | 40 | ||||
43332 | 110591 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1160X PORTOLA DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994964 | 2098019 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | 1 | 8 | 4 | 59 | 40 | ||||
104452 | 110629 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1000X MANDALAY LN | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |||||
114036 | 110695 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 56 CARVER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009400 | 2098407 | 37.7423565789738 | -122.410108989973 | (37.7423565789738, -122.410108989973) | 10 | 7 | 7 | 28859 | 2 | ||||
169770 | 110740 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3521x SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
37646 | 110789 | Section 143 10 | Pinus radiata :: Monterey Pine 15 | 850x SANCHEZ ST | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6003717 | 2103349 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | 2 | 4 | 5 | 28862 | 22 | ||||
162115 | 110876 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
192018 | 110881 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
171140 | 110890 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
40432 | 110929 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 445 BEACON ST | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002243 | 2098437 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | 2 | 7 | 5 | 63 | 7 | |||||
131954 | 110939 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout | Tree | Private 2 | 30 | 3x3 | 5992046 | 2088201 | 37.7133454608488 | -122.46937060641 | (37.7133454608488, -122.46937060641) | 9 | 8 | 6 | 64 | 24 | |||
143770 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 342 HILL ST | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 778799 | 6004048 | 2103384 | 37.7557208285242 | -122.428969343229 | (37.7557208285242, -122.428969343229) | 2 | 4 | 5 | 28862 | 22 | |||
133009 | 110951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
141742 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
146688 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
126836 | 111051 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1651X PORTOLA DR | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 50x100 | 5992099 | 2096127 | 37.7351113665941 | -122.469764107515 | (37.7351113665941, -122.469764107515) | 1 | 8 | 4 | 59 | 40 | ||||
164792 | 111088 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 136 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 45 | 3x3 | Permit Number 775596 | 5990091 | 2089770 | 37.7175403760398 | -122.476242228391 | (37.7175403760398, -122.476242228391) | 1 | 8 | 4 | 64 | 14 | |
47284 | 111091 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 423 GONZALEZ DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775595 | 5989758 | 2089186 | 37.715917540265 | -122.477350587483 | (37.715917540265, -122.477350587483) | 1 | 8 | 4 | 64 | 14 | |
133714 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916 | 2088996 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | 1 | 8 | 4 | 64 | 14 | |
34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
152661 | 111245 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 799X SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
91085 | 111308 | Private 9 | Pinus radiata :: Monterey Pine 15 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x90 | 6015099 | 2088640 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | 10 | 3 | 8 | 58 | 1 | ||||
129885 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 600x MANSELL ST | 1 | Front Yard : Cutout | Tree | DPW 1 | 48 | 3x3 | 6010142 | 2090267 | 37.7200474236955 | -122.406969764511 | (37.7200474236955, -122.406969764511) | 10 | 3 | 8 | 309 | 28 | |||
86421 | 111360 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 101x SERRANO DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | 3x3 | 5989748 | 2090663 | 37.7199724349458 | -122.477493041793 | (37.7199724349458, -122.477493041793) | 1 | 8 | 4 | 64 | 14 | |||
168033 | 111379 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
119304 | 111381 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
119676 | 111396 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 1 | Median : Yard | Tree | Private 2 | 53 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
114181 | 111397 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 2 | Median : Yard | Tree | Private 2 | 36 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
92974 | 111398 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 3 | Median : Yard | Tree | Private 2 | 4 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
145621 | 111399 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 4 | Median : Yard | Tree | Private 2 | 48 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
64613 | 111400 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 5 | Median : Yard | Tree | Private 2 | 54 | Permit Number 779360 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | |||
154936 | 111401 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 6 | Median : Yard | Tree | Private 2 | 40 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
26965 | 111402 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 7 | Median : Yard | Tree | Private 2 | 29 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
46595 | 111403 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 8 | Median : Yard | Tree | Private 2 | 28 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
81287 | 111404 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 9 | Median : Yard | Tree | Private 2 | 48 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
37123 | 111405 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 10 | Median : Yard | Tree | Private 2 | 50 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
99168 | 111406 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 1 | Median : Yard | Tree | Private 2 | 40 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
92232 | 111407 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 2 | Median : Yard | Tree | Private 2 | 12 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
130812 | 111408 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 3 | Median : Yard | Tree | Private 2 | 15 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
185742 | 111409 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 4 | Median : Yard | Tree | Private 2 | 45 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
166711 | 111410 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 5 | Median : Yard | Tree | Private 2 | 10 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
159659 | 111411 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 6 | Median : Yard | Tree | Private 2 | 12 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );