trees
8,758 rows where qSpecies_id = 16 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103878 | 105253 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | ||||
10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
84894 | 105259 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 466 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | ||||
20590 | 10526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010016.24586 | 2090146.56283 | 37.7197096903227 | -122.40739596955 | (37.7197096903227, -122.40739596955) | 9 | 7 | 8 | 309 | 18 | |||
137862 | 105335 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5984535.7811 | 2098197.6228 | 37.7403566801373 | -122.496065194743 | (37.7403566801373, -122.496065194743) | 1 | 8 | 3 | 29491 | 35 | |||
60539 | 105336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | 6x3 | 5982517.1089 | 2104591.5856 | 37.7577942749992 | -122.503518205917 | (37.7577942749992, -122.503518205917) | 1 | 8 | 3 | 56 | 35 | |||
112400 | 105339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1210 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5983372.8821 | 2106845.209 | 37.7640323622113 | -122.500725281949 | (37.7640323622113, -122.500725281949) | 1 | 8 | 3 | 56 | 35 | |||
108660 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.445678167683 | (37.7642451591147, -122.445678167683) | 15 | 5 | 5 | 29492 | 9 | ||||||
185768 | 105370 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 518 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989481.9 | 2089475.9 | 37.7166975095441 | -122.478326092697 | (37.7166975095441, -122.478326092697) | 1 | 8 | 4 | 64 | 14 | ||||
34938 | 105419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2310 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6003748.57282 | 2116457.88739 | 37.7916015595189 | -122.430937881603 | (37.7916015595189, -122.430937881603) | 13 | 9 | 1 | 29490 | 27 | ||||
67018 | 105420 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2310 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771076 | 6003772.4 | 2116466.9 | 37.7916276558922 | -122.430856083318 | (37.7916276558922, -122.430856083318) | 13 | 9 | 1 | 29490 | 27 | |||
162039 | 105498 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 18TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x7 | 5990531.6 | 2106943.9 | 37.7647210201696 | -122.475972851989 | (37.7647210201696, -122.475972851989) | 11 | 8 | 3 | 56 | 12 | |||
81541 | 105499 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 18TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x10.5 | 5990531.6 | 2106943.9 | 37.7647210201696 | -122.475972851989 | (37.7647210201696, -122.475972851989) | 11 | 8 | 3 | 56 | 12 | |||
14003 | 105527 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 228 Collins St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 5998178.2908 | 2113055.0752 | 37.7819411428258 | -122.449965554893 | (37.7819411428258, -122.449965554893) | 15 | 6 | 2 | 54 | 16 | |||
54797 | 1057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2050 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000403.71469 | 2090207.68869 | 37.7193348205218 | -122.440627358991 | (37.7193348205218, -122.440627358991) | 9 | 7 | 6 | 28861 | 25 | |||
87696 | 10570 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1627X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001699.84573 | 2092558.73555 | 37.7258639896378 | -122.436315294479 | (37.7258639896378, -122.436315294479) | 9 | 7 | 6 | 28861 | 25 | |||
118608 | 105714 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40X 18TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x9 | 5990254.2 | 2114862 | 37.7864458560817 | -122.477511071909 | (37.7864458560817, -122.477511071909) | 11 | 6 | 1 | 55 | 33 | |||
23611 | 105825 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 945 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x30 | 6000350.1 | 2101885.4 | 37.7513960287233 | -122.441650282448 | (37.7513960287233, -122.441650282448) | 2 | 4 | 5 | 28862 | 22 | |||
43538 | 105826 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 945 ELIZABETH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x30 | 6000350.1 | 2101885.4 | 37.7513960287233 | -122.441650282448 | (37.7513960287233, -122.441650282448) | 2 | 4 | 5 | 28862 | 22 | |||
191048 | 105827 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 930 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6000439.7 | 2102016.1 | 37.7517600039536 | -122.441349813189 | (37.7517600039536, -122.441349813189) | 2 | 4 | 5 | 28862 | 22 | ||||
21869 | 1059 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2058 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6000366.95559 | 2090175.28019 | 37.7192437407752 | -122.440752097656 | (37.7192437407752, -122.440752097656) | 9 | 7 | 6 | 28861 | 25 | |||
125830 | 105905 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4525 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5981638.9799 | 2106209.1871 | 37.762184081194 | -122.506675059048 | (37.762184081194, -122.506675059048) | 1 | 8 | 3 | 56 | 35 | |||
11358 | 105913 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.392653238457 | (37.7932348296087, -122.392653238457) | 12 | 2 | 9 | 28855 | 6 | |||
46539 | 105914 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.392653238457 | (37.7932348296087, -122.392653238457) | 12 | 2 | 9 | 28855 | 6 | |||
142066 | 105915 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.392653238457 | (37.7932348296087, -122.392653238457) | 12 | 2 | 9 | 28855 | 6 | |||
53044 | 105965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 56 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5998972.38609 | 2116342.40788 | 37.791012702325 | -122.447455054208 | (37.791012702325, -122.447455054208) | 13 | 6 | 1 | 29490 | 31 | ||||
28072 | 10607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 22 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6016994.80167 | 2095495.89651 | 37.7347860393267 | -122.383645581171 | (37.7347860393267, -122.383645581171) | 10 | 3 | 8 | 58 | 1 | |||
13537 | 10608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6016953.56125 | 2095500.30528 | 37.7347958653241 | -122.383788471781 | (37.7347958653241, -122.383788471781) | 10 | 3 | 8 | 58 | 1 | |||
100903 | 10609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 26 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6016979.52337 | 2095525.43056 | 37.7348662894378 | -122.383700459617 | (37.7348662894378, -122.383700459617) | 10 | 3 | 8 | 58 | 1 | |||
45855 | 10611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6016969.80707 | 2095548.58969 | 37.7349293427129 | -122.383735664494 | (37.7349293427129, -122.383735664494) | 10 | 3 | 8 | 58 | 1 | |||
33325 | 10615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6016878.19389 | 2095639.30645 | 37.7351733683384 | -122.384058721653 | (37.7351733683384, -122.384058721653) | 10 | 3 | 8 | 58 | 1 | |||
113172 | 10616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 54 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6016854.17886 | 2095636.50917 | 37.735164359841 | -122.384141556392 | (37.735164359841, -122.384141556392) | 10 | 3 | 8 | 58 | 1 | |||
108224 | 1062 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2063X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 24 | 3X3 | 6000425.07348 | 2090112.17888 | 37.719073788482 | -122.440546683168 | (37.719073788482, -122.440546683168) | 9 | 7 | 6 | 28861 | 25 | ||
111496 | 106221 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 940 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000384 | 2101992 | 37.7516906579726 | -122.441540701476 | (37.7516906579726, -122.441540701476) | 2 | 4 | 5 | 28862 | 22 | |||
70356 | 106222 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 940 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000384 | 2101992 | 37.7516906579726 | -122.441540701476 | (37.7516906579726, -122.441540701476) | 2 | 4 | 5 | 28862 | 22 | |||
61884 | 106259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1812 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x6 | 5988352.6604 | 2103108.1181 | 37.7540624217556 | -122.483227952644 | (37.7540624217556, -122.483227952644) | 1 | 8 | 3 | 56 | 35 | |||
46945 | 106319 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1159 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 773066 | 6012250.50894 | 2103016.72008 | 37.7551732357645 | -122.400576477945 | (37.7551732357645, -122.400576477945) | 10 | 3 | 8 | 28856 | 29 | ||
33176 | 106320 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1159 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 773066 | 6012249.74614 | 2103033.73104 | 37.7552199015978 | -122.40058031085 | (37.7552199015978, -122.40058031085) | 10 | 3 | 8 | 28856 | 29 | ||
180663 | 106366 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 SEAL ROCK DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981833.1 | 2112945.4 | 37.7806911884837 | -122.506503269885 | (37.7806911884837, -122.506503269885) | 11 | 6 | 2 | 55 | 26 | ||||||
50749 | 106403 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600-698X BOWDOIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008958 | 2093051 | 37.7276253752452 | -122.411259027338 | (37.7276253752452, -122.411259027338) | 9 | 3 | 7 | 309 | 28 | |||||
189758 | 106480 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 310X LAWTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
11227 | 106481 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
75372 | 106482 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
58304 | 106493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2032 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x9 | 5999399.4013 | 2111206.8691 | 37.7769362403837 | -122.445608143481 | (37.7769362403837, -122.445608143481) | 15 | 5 | 11 | 29492 | 16 | |||
82912 | 106537 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 461 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | I marked basin expansion. SB | 6000706.4 | 2101348.7 | 37.7499426736315 | -122.440379671461 | (37.7499426736315, -122.440379671461) | 2 | 4 | 5 | 28862 | 22 | ||||
108739 | 106538 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 461 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Basin expansion. Sb | 6000706.4 | 2101348.7 | 37.7499426736315 | -122.440379671461 | (37.7499426736315, -122.440379671461) | 2 | 4 | 5 | 28862 | 22 | ||||
120056 | 106629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4701X 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5998637 | 2105671 | 37.7616925944437 | -122.447846869296 | (37.7616925944437, -122.447846869296) | 15 | 5 | 11 | 29492 | 12 | |||
131888 | 106658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 256 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6001495.79596 | 2120724.12156 | 37.8031876171793 | -122.439038335152 | (37.8031876171793, -122.439038335152) | 13 | 9 | 1 | 57 | 17 | ||||
41558 | 10666 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1015 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6002966.2768 | 2110616.4892 | 37.7755181964859 | -122.433227045109 | (37.7755181964859, -122.433227045109) | 15 | 5 | 11 | 29492 | 10 | |||
185222 | 10668 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1027 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6002900.4751 | 2110607.2358 | 37.7754890559117 | -122.43345400737 | (37.7754890559117, -122.43345400737) | 15 | 5 | 11 | 29492 | 10 | |||
80344 | 106707 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X BRIGHTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5996224 | 2090880 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | 9 | 8 | 6 | 28861 | 24 | |||
112598 | 10671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002659.3771 | 2110570.8701 | 37.7753755231217 | -122.434285421548 | (37.7753755231217, -122.434285421548) | 15 | 5 | 11 | 29492 | 10 | |||
156493 | 106715 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987099 | 2115331 | 37.7875500018464 | -122.488461609309 | (37.7875500018464, -122.488461609309) | 11 | 6 | 1 | 55 | 33 | |||||
86583 | 106716 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987099 | 2115331 | 37.7875500018464 | -122.488461609309 | (37.7875500018464, -122.488461609309) | 11 | 6 | 1 | 55 | 33 | |||||
23193 | 10672 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002688.4855 | 2110577.4857 | 37.775395340044 | -122.43418520195 | (37.775395340044, -122.43418520195) | 15 | 5 | 11 | 29492 | 10 | |||
60166 | 10673 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002708.9937 | 2110579.4703 | 37.7754019532117 | -122.434114401257 | (37.7754019532117, -122.434114401257) | 15 | 5 | 11 | 29492 | 10 | |||
190564 | 10674 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002728.1788 | 2110582.7781 | 37.7754121244262 | -122.434048272069 | (37.7754121244262, -122.434048272069) | 15 | 5 | 11 | 29492 | 10 | |||
104860 | 10675 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002771.1799 | 2110588.7321 | 37.7754309129501 | -122.433899946977 | (37.7754309129501, -122.433899946977) | 15 | 5 | 11 | 29492 | 10 | |||
41538 | 10676 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002794.3343 | 2110592.0399 | 37.7754413092856 | -122.433820087 | (37.7754413092856, -122.433820087) | 15 | 5 | 11 | 29492 | 10 | |||
166935 | 10677 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002817.4888 | 2110594.0246 | 37.7754480726687 | -122.433740132069 | (37.7754480726687, -122.433740132069) | 15 | 5 | 11 | 29492 | 10 | |||
98936 | 10678 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002838.6585 | 2110596.6708 | 37.7754565396927 | -122.433667090298 | (37.7754565396927, -122.433667090298) | 15 | 5 | 11 | 29492 | 10 | |||
181864 | 106796 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 331 LAWTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6x9 | 5993227.5 | 2104541.1 | 37.7582795066077 | -122.466473865592 | (37.7582795066077, -122.466473865592) | 1 | 8 | 4 | 56 | 12 | |||
122738 | 106885 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 419 LAWTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x6 | 5992951.6 | 2104493.8 | 37.7581337087803 | -122.467424600923 | (37.7581337087803, -122.467424600923) | 1 | 8 | 4 | 56 | 12 | |||
110277 | 10691 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1245 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001914.4034 | 2110469.3909 | 37.7750545742745 | -122.436855188969 | (37.7750545742745, -122.436855188969) | 15 | 5 | 11 | 29492 | 10 | |||
36851 | 106910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3536 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997359.13983 | 2116076.95534 | 37.7901915187728 | -122.453017625461 | (37.7901915187728, -122.453017625461) | 11 | 6 | 1 | 54 | 31 | |
125377 | 106911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3536 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997340.42216 | 2116075.24554 | 37.7901857514154 | -122.45308226335 | (37.7901857514154, -122.45308226335) | 11 | 6 | 1 | 54 | 31 | |
180806 | 106919 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 18TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990580 | 2105509.7 | 37.760785897588 | -122.475700713403 | (37.760785897588, -122.475700713403) | 1 | 8 | 4 | 56 | 12 | |||||
167842 | 10704 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130X Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993684.4832438 | 2089860.5757616 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | 9 | 8 | 6 | 64 | 24 | |||
95575 | 10707 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 Hillview Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6016646.30377 | 2095798.45796 | 37.7355975434989 | -122.384871541503 | (37.7355975434989, -122.384871541503) | 10 | 3 | 8 | 58 | 1 | |||
34094 | 10709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 Hillview Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6016599.83487 | 2095766.29094 | 37.7355066490105 | -122.385029963356 | (37.7355066490105, -122.385029963356) | 10 | 3 | 8 | 58 | 1 | |||
152458 | 107114 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 650 CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6004239 | 2105070 | 37.7603609947439 | -122.428428970167 | (37.7603609947439, -122.428428970167) | 2 | 4 | 5 | 28862 | 3 | |||
104855 | 107143 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1506 47TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5981601.8 | 2104810 | 37.7583401244926 | -122.506699867993 | (37.7583401244926, -122.506699867993) | 1 | 8 | 3 | 56 | 35 | |||
191946 | 107167 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 27 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993261.4 | 2098012.7 | 37.7403561458765 | -122.465882276537 | (37.7403561458765, -122.465882276537) | 1 | 8 | 4 | 59 | 40 | |||||
30065 | 107237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6017131 | 2095773 | 37.7355544375929 | -122.383193973215 | (37.7355544375929, -122.383193973215) | 10 | 3 | 8 | 58 | 1 | ||||
22967 | 107296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 12 | Permit Number 773475 | 5982185.6184 | 2096841.85092 | 37.7364961680662 | -122.504090589396 | (37.7364961680662, -122.504090589396) | 1 | 8 | 3 | 29491 | 35 | ||
38294 | 107304 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990843 | 2105531 | 37.7608596255093 | -122.47479267759 | (37.7608596255093, -122.47479267759) | 1 | 8 | 4 | 56 | 12 | |||||
132809 | 107305 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X 17TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990843 | 2105531 | 37.7608596255093 | -122.47479267759 | (37.7608596255093, -122.47479267759) | 1 | 8 | 4 | 56 | 12 | |||||
138280 | 107395 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
121353 | 107397 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
116341 | 107398 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | |||||
111314 | 1074 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2118 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000073.74803 | 2089898.48202 | 37.7184670134303 | -122.441745747777 | (37.7184670134303, -122.441745747777) | 9 | 7 | 6 | 28861 | 25 | |||
173831 | 10750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
72051 | 10759 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
171107 | 107591 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2760 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6000103.81735 | 2118107.41373 | 37.7959235348996 | -122.443667208689 | (37.7959235348996, -122.443667208689) | 13 | 9 | 1 | 57 | 17 | |||
97568 | 10765 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120X Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | 3X4 | 6017565.89701 | 2094869.68831 | 37.7330981455592 | -122.381627551172 | (37.7330981455592, -122.381627551172) | 10 | 3 | 8 | 58 | 1 | ||
158117 | 107675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98x LUNDYS LN | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 8x10 | 6006855 | 2099015 | 37.7438830341993 | -122.418951960739 | (37.7438830341993, -122.418951960739) | 2 | 7 | 7 | 28859 | 2 | |||
56495 | 107710 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1798X 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | |
158402 | 107713 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1798X 31st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | |
56175 | 107714 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1798X 31st Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | |
50287 | 107758 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005605.1 | 2096623 | 37.7372446808015 | -122.423103843591 | (37.7372446808015, -122.423103843591) | 2 | 7 | 7 | 28859 | 2 | |||||
179768 | 1078 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2130 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000037.95609 | 2089861.39052 | 37.7183631291423 | -122.441866804631 | (37.7183631291423, -122.441866804631) | 9 | 7 | 6 | 28861 | 25 | |||
92977 | 107812 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 CARMEL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x9 | 5998702.7 | 2105350.6 | 37.7608166111569 | -122.447596575844 | (37.7608166111569, -122.447596575844) | 15 | 5 | 11 | 29492 | 12 | |||
127344 | 107877 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014726.8505 | 2116848.52967 | 37.7932900942187 | -122.392980200487 | (37.7932900942187, -122.392980200487) | 12 | 2 | 9 | 28855 | 6 | |||
169261 | 107878 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014739.78299 | 2116857.93576 | 37.7933166395083 | -122.392936111232 | (37.7933166395083, -122.392936111232) | 12 | 2 | 9 | 28855 | 6 | |||
171647 | 107879 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6014751.56327 | 2116870.38597 | 37.7933514792271 | -122.392896221779 | (37.7933514792271, -122.392896221779) | 12 | 2 | 9 | 28855 | 6 | |||
172998 | 107880 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014765.78181 | 2116883.39117 | 37.793387978235 | -122.392847934511 | (37.793387978235, -122.392847934511) | 12 | 2 | 9 | 28855 | 6 | |||
101956 | 107881 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014777.27109 | 2116896.45157 | 37.7934244772004 | -122.392809094575 | (37.7934244772004, -122.392809094575) | 12 | 2 | 9 | 28855 | 6 | |||
5948 | 107882 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1x Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014791.78085 | 2116908.84659 | 37.7934593169345 | -122.392759756859 | (37.7934593169345, -122.392759756859) | 12 | 2 | 9 | 28855 | 6 | |||
51029 | 107941 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2340X 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011168.26804 | 2103694.61992 | 37.7569741821224 | -122.404366917079 | (37.7569741821224, -122.404366917079) | 10 | 4 | 8 | 28859 | 19 | |||
146542 | 10811 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/1993 12:00:00 AM | 8 | 3X4 | 6017631.41001 | 2094765.88801 | 37.7328167474611 | -122.381393837439 | (37.7328167474611, -122.381393837439) | 10 | 3 | 8 | 58 | 1 |
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) );