trees
8,758 rows where qSpecies_id = 16 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
73401 | 12919 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x9 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
27750 | 110300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3521 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5993646.27224 | 2087441.41839 | 37.7113521790304 | -122.463784453814 | (37.7113521790304, -122.463784453814) | 9 | 8 | 4 | 64 | 24 | |||
158741 | 177596 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2969 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2018 12:00:00 AM | 17 | Width 2ft | 5996863.1047 | 2087380.04976 | 37.7113685215187 | -122.452661893251 | (37.7113685215187, -122.452661893251) | 9 | 7 | 6 | 28861 | 25 | ||
41432 | 177712 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3597 Alemany Blvd | 2 | : | Tree | Private 2 | 18 | Width 3ft | 5993573.43523 | 2087465.73541 | 37.7114147502636 | -122.464037959205 | (37.7114147502636, -122.464037959205) | 9 | 8 | 4 | 64 | 24 | |||
67538 | 177597 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2969 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 2ft | 5996885.02148 | 2087397.68975 | 37.7114182126546 | -122.452587415894 | (37.7114182126546, -122.452587415894) | 9 | 7 | 6 | 28861 | 25 | |||
138802 | 1285 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3904 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 9x5 | 5992558.6602 | 2087490.11279 | 37.7114231481267 | -122.467547024769 | (37.7114231481267, -122.467547024769) | 9 | 8 | 4 | 64 | 24 | |||
48263 | 12914 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2961X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 5996894.33431 | 2087406.2104 | 37.7114421419884 | -122.45255584304 | (37.7114421419884, -122.45255584304) | 9 | 7 | 6 | 28861 | 25 | |||
95125 | 12915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2961X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 5996894.33431 | 2087406.2104 | 37.7114421419884 | -122.45255584304 | (37.7114421419884, -122.45255584304) | 9 | 7 | 6 | 28861 | 25 | |||
151013 | 12916 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2961X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5996894.33431 | 2087406.2104 | 37.7114421419884 | -122.45255584304 | (37.7114421419884, -122.45255584304) | 9 | 7 | 6 | 28861 | 25 | |||
109451 | 1219 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3575X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3X3 | 5993629.70146 | 2087487.19649 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | 9 | 8 | 4 | 64 | 24 | |||
167581 | 177598 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2969 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 4ft | 5996913.03077 | 2087421.14861 | 37.7114842300863 | -122.452492300898 | (37.7114842300863, -122.452492300898) | 9 | 7 | 6 | 28861 | 25 | |||
152809 | 65691 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 298 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/1990 12:00:00 AM | Permit Number 28617 | 6000465.61879312 | 2087349.15527737 | 37.7114894548419 | -122.440208500633 | (37.7114894548419, -122.440208500633) | 9 | 7 | 6 | 28861 | 5 | ||
124583 | 177583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 617 Morse St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999354.17017 | 2087374.3203 | 37.7114952108205 | -122.444051751609 | (37.7114952108205, -122.444051751609) | 9 | 7 | 6 | 28861 | 5 | |||
87912 | 258213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 225X Head St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5993438 | 2087500 | 37.7115010262354 | -122.4645085409 | (37.7115010262354, -122.4645085409) | 9 | 8 | 4 | 64 | 24 | ||||
183187 | 177636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000839.34654 | 2087353.43494 | 37.7115224764632 | -122.438917109259 | (37.7115224764632, -122.438917109259) | 9 | 7 | 6 | 28861 | 5 | |||
180920 | 177581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 617 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999217.96751 | 2087390.18083 | 37.7115309894406 | -122.444523641174 | (37.7115309894406, -122.444523641174) | 9 | 7 | 6 | 28861 | 5 | |||
105145 | 177582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 617 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999225.92078 | 2087392.71996 | 37.7115384151318 | -122.444496335044 | (37.7115384151318, -122.444496335044) | 9 | 7 | 6 | 28861 | 5 | |||
55666 | 177637 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6000833.77764 | 2087370.24547 | 37.7115683175965 | -122.438937560743 | (37.7115683175965, -122.438937560743) | 9 | 7 | 6 | 28861 | 5 | |||
43122 | 1232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3609 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5993415.10362 | 2087526.3221 | 37.7115719805367 | -122.464589586241 | (37.7115719805367, -122.464589586241) | 9 | 8 | 4 | 64 | 24 | |||
162545 | 175044 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 5991568.94889 | 2087568.22246 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | 9 | 8 | 4 | 64 | 24 | |||
76793 | 65722 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 293 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28656 | 6000507.50503755 | 2087389.37398756 | 37.7116022711096 | -122.440066613266 | (37.7116022711096, -122.440066613266) | 9 | 7 | 6 | 28861 | 5 | ||
149842 | 177638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Curtis St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6000829.15381 | 2087385.07256 | 37.7116087664118 | -122.438954603793 | (37.7116087664118, -122.438954603793) | 9 | 7 | 6 | 28861 | 5 | |||
21715 | 1234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3633 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993305.81701 | 2087547.31495 | 37.7116233210332 | -122.464968830366 | (37.7116233210332, -122.464968830366) | 9 | 8 | 4 | 64 | 24 | |||
12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
40208 | 175046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 5991566.54873 | 2087591.25852 | 37.7116435395983 | -122.470983349614 | (37.7116435395983, -122.470983349614) | 9 | 8 | 4 | 64 | 24 | |||
86448 | 213220 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 128 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5995906.87755 | 2087506.24432 | 37.7116601851533 | -122.455975956129 | (37.7116601851533, -122.455975956129) | 9 | 8 | 6 | 28861 | 24 | |||
57957 | 65738 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 138 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | Permit Number 28674 | 6000620.61991485 | 2087410.58476981 | 37.7116669501241 | -122.439677178701 | (37.7116669501241, -122.439677178701) | 9 | 7 | 6 | 28861 | 5 | ||
82040 | 254873 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 5996042.96304 | 2087509.51727 | 37.711676981779 | -122.455505847225 | (37.711676981779, -122.455505847225) | 9 | 8 | 6 | 28861 | 24 | ||||
6975 | 213248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5996050.31606 | 2087518.48106 | 37.7117020161965 | -122.455481080804 | (37.7117020161965, -122.455481080804) | 9 | 8 | 6 | 28861 | 24 | |||
11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
18949 | 65737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 47 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 10 | Permit Number 33496 | 6000834.88494 | 2087430.71452 | 37.7117344151764 | -122.438938064335 | (37.7117344151764, -122.438938064335) | 9 | 7 | 6 | 28861 | 5 | |
131072 | 65736 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 10 | Permit Number 28672 | 6000856.98102 | 2087436.5842 | 37.7117517891768 | -122.438862114789 | (37.7117517891768, -122.438862114789) | 9 | 7 | 6 | 28861 | 5 | |
25924 | 213221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 128 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5995907.58911 | 2087540.28441 | 37.7117536921647 | -122.455975956126 | (37.7117536921647, -122.455975956126) | 9 | 8 | 6 | 28861 | 24 | |||
188268 | 6862 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5997022.14181 | 2087520.25772 | 37.711762611705 | -122.452122332906 | (37.711762611705, -122.452122332906) | 9 | 7 | 6 | 28861 | 25 | |||
178054 | 213247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2950 San Jose Ave | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5996077.12469 | 2087544.08394 | 37.7117738540499 | -122.455390272656 | (37.7117738540499, -122.455390272656) | 9 | 8 | 6 | 28861 | 24 | |||
183453 | 1255 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3800X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X5 | 5992948.4963594 | 2087630.4709831 | 37.7118310379998 | -122.466209855136 | (37.7118310379998, -122.466209855136) | 9 | 8 | 4 | 64 | 24 | |||
27790 | 1239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3702X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X5 | 5993039.27607 | 2087635.23978 | 37.711849369237 | -122.465896444163 | (37.711849369237, -122.465896444163) | 9 | 8 | 4 | 64 | 24 | |||
54559 | 177599 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 2ft | 5997064.22981 | 2087562.19472 | 37.7118801719014 | -122.451979889667 | (37.7118801719014, -122.451979889667) | 9 | 7 | 6 | 28861 | 25 | |||
29304 | 65744 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 184 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 11 | Permit Number 28703 | 6000756.34177 | 2087488.39058 | 37.7118883116738 | -122.439213661599 | (37.7118883116738, -122.439213661599) | 9 | 7 | 6 | 28861 | 5 | |
61350 | 1168 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5996977.74634 | 2087593.42231 | 37.7119609615978 | -122.452281051028 | (37.7119609615978, -122.452281051028) | 9 | 7 | 6 | 28861 | 25 | |||
104029 | 1167 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5996996.31742 | 2087611.15938 | 37.7120107273862 | -122.452218143458 | (37.7120107273862, -122.452218143458) | 9 | 7 | 6 | 28861 | 25 | |||
32216 | 65720 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28652 | 6000403.76126998 | 2087546.45135602 | 37.7120276638869 | -122.440436436812 | (37.7120276638869, -122.440436436812) | 9 | 7 | 6 | 28861 | 5 | ||
90363 | 65719 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 249 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28651 | 6000450.80231041 | 2087570.22871864 | 37.7120956296414 | -122.440275554004 | (37.7120956296414, -122.440275554004) | 9 | 7 | 6 | 28861 | 5 | ||
108642 | 177600 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2899 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5997154.22581 | 2087648.86391 | 37.7121233000332 | -122.451675087832 | (37.7121233000332, -122.451675087832) | 9 | 7 | 6 | 28861 | 25 | |||
65045 | 6859 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2865X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3X3 | 5997253 | 2087738 | 37.7123737035526 | -122.451340121886 | (37.7123737035526, -122.451340121886) | 9 | 7 | 6 | 28861 | 25 | |||
121268 | 1158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2850 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5.5x12 | 5997188.96835 | 2087794.05096 | 37.7125239399081 | -122.451565473989 | (37.7125239399081, -122.451565473989) | 9 | 7 | 6 | 28861 | 25 | |||
163324 | 177685 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1669 Geneva Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003327.32245 | 2087681.01569 | 37.7125631836054 | -122.430341370261 | (37.7125631836054, -122.430341370261) | 9 | 7 | 6 | 28861 | 5 | |||
15300 | 177686 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1669 Geneva Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003304.44382 | 2087685.74457 | 37.7125748721142 | -122.430420783092 | (37.7125748721142, -122.430420783092) | 9 | 7 | 6 | 28861 | 5 | |||
98002 | 1157 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2850 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 5.5x18 | 5997212.55332 | 2087815.83701 | 37.7125851099963 | -122.451485527846 | (37.7125851099963, -122.451485527846) | 9 | 7 | 6 | 28861 | 25 | |||
68611 | 177635 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001299.26955 | 2087763.80738 | 37.7126754253012 | -122.43735686374 | (37.7126754253012, -122.43735686374) | 9 | 7 | 6 | 28861 | 5 | |||
137478 | 69399 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 12 | Permit Number 33503 | 6001308.66281 | 2087780.20224 | 37.7127209759558 | -122.43732557094 | (37.7127209759558, -122.43732557094) | 9 | 7 | 6 | 28861 | 5 | |
185631 | 65711 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 183 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28640 | 6000357.33752314 | 2087867.01462621 | 37.7129052154824 | -122.440619868487 | (37.7129052154824, -122.440619868487) | 9 | 7 | 6 | 28861 | 5 | ||
30822 | 26092 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5996314.86331 | 2088032.22546 | 37.7131278157601 | -122.454603829924 | (37.7131278157601, -122.454603829924) | 9 | 8 | 6 | 28861 | 24 | |||
130892 | 26093 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 31 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5996341.26672 | 2088032.78427 | 37.7131308644821 | -122.454512611691 | (37.7131308644821, -122.454512611691) | 9 | 8 | 6 | 28861 | 24 | |||
3734 | 67984 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.454381139129 | (37.713134273022, -122.454381139129) | 9 | 8 | 6 | 28861 | 24 | ||
14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
70612 | 65710 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 149 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28639 | 6000308.37979059 | 2088020.81752427 | 37.7133247357467 | -122.440800107895 | (37.7133247357467, -122.440800107895) | 9 | 7 | 6 | 28861 | 5 | ||
8472 | 65709 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28638 | 6000250.18995538 | 2088032.18663542 | 37.7133526386349 | -122.44100204672 | (37.7133526386349, -122.44100204672) | 9 | 7 | 6 | 28861 | 5 | ||
140486 | 65713 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 89 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 9 | Permit Number 28643 | 6000950.04097 | 2088044.64791 | 37.7134266910691 | -122.438584015644 | (37.7134266910691, -122.438584015644) | 9 | 7 | 6 | 28861 | 5 | |
137375 | 65708 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 133 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28637 | 6000285.34085826 | 2088093.19535666 | 37.713522156937 | -122.440884927142 | (37.713522156937, -122.440884927142) | 9 | 7 | 6 | 28861 | 5 | ||
182824 | 177792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290x Rolph St | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6001464.09036 | 2088085.72956 | 37.7135687209947 | -122.436810222515 | (37.7135687209947, -122.436810222515) | 9 | 7 | 6 | 28861 | 5 | |||
128739 | 213269 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 58 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992208.01745 | 2088290.25795 | 37.7135999031885 | -122.468817113946 | (37.7135999031885, -122.468817113946) | 9 | 8 | 6 | 64 | 24 | |||
114420 | 177634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Cross St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000105.48742 | 2088227.22845 | 37.7138799367815 | -122.441516175146 | (37.7138799367815, -122.441516175146) | 9 | 7 | 6 | 28861 | 5 | |||
167599 | 177633 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Cross St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000123.19321 | 2088232.8041 | 37.7138962549828 | -122.441455377363 | (37.7138962549828, -122.441455377363) | 9 | 7 | 6 | 28861 | 5 | |||
73592 | 177632 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Cross St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000145.06775 | 2088240.48411 | 37.7139185887391 | -122.44138032174 | (37.7139185887391, -122.44138032174) | 9 | 7 | 6 | 28861 | 5 | |||
173874 | 177631 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Cross St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000167.63254 | 2088247.91236 | 37.7139402704917 | -122.441302862262 | (37.7139402704917, -122.441302862262) | 9 | 7 | 6 | 28861 | 5 | |||
55840 | 66807 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 243 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1991 12:00:00 AM | 4 | 3x3 | Permit Number 30090 | 5994595.1309662 | 2088375.9253033 | 37.7139727473786 | -122.460572653796 | (37.7139727473786, -122.460572653796) | 9 | 8 | 6 | 28861 | 24 | |
57702 | 67016 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 215 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30371 | 5994871.17001084 | 2088372.66088411 | 37.7139796610332 | -122.459618329087 | (37.7139796610332, -122.459618329087) | 9 | 8 | 6 | 28861 | 24 | ||
44229 | 67017 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30372 | 5994910.60415876 | 2088372.19453853 | 37.713980648067 | -122.459481996976 | (37.713980648067, -122.459481996976) | 9 | 8 | 6 | 28861 | 24 | ||
63718 | 1154 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2694 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5997931.7588 | 2088310.0454 | 37.7139832518084 | -122.449035319534 | (37.7139832518084, -122.449035319534) | 9 | 7 | 6 | 28861 | 25 | |||
180782 | 213227 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5993763.65935 | 2088398.01235 | 37.7139855225771 | -122.46344811274 | (37.7139855225771, -122.46344811274) | 9 | 8 | 6 | 64 | 24 | |||
35516 | 213213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 243 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994556.90102 | 2088381.98858 | 37.7139871962159 | -122.46070522909 | (37.7139871962159, -122.46070522909) | 9 | 8 | 6 | 28861 | 24 | |||
105153 | 1150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2679 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998099.81535 | 2088308.11264 | 37.7139875550587 | -122.448454316117 | (37.7139875550587, -122.448454316117) | 9 | 7 | 6 | 28861 | 25 | |||
30886 | 213214 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994624.29894 | 2088382.43023 | 37.713992286394 | -122.46047231006 | (37.713992286394, -122.46047231006) | 9 | 8 | 6 | 28861 | 24 | |||
12020 | 32737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 223 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | Permit Number 37120 | 5994748.23288 | 2088380.20466 | 37.7139933044225 | -122.460043789395 | (37.7139933044225, -122.460043789395) | 9 | 8 | 6 | 28861 | 24 | |
40905 | 213216 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994887.0913 | 2088379.52093 | 37.7139994126132 | -122.459563796032 | (37.7139994126132, -122.459563796032) | 9 | 8 | 6 | 28861 | 24 | |||
145804 | 213215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 215 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5994864.01806 | 2088380.00414 | 37.7139994126199 | -122.459643580303 | (37.7139994126199, -122.459643580303) | 9 | 8 | 6 | 28861 | 24 | |||
167859 | 1147 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2673 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X5 | 5998124.85608 | 2088323.06996 | 37.7140300561224 | -122.448368842743 | (37.7140300561224, -122.448368842743) | 9 | 7 | 6 | 28861 | 25 | |||
12017 | 213228 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993764.44098 | 2088418.41063 | 37.7140415764298 | -122.46344689056 | (37.7140415764298, -122.46344689056) | 9 | 8 | 6 | 64 | 24 | |||
63592 | 1151 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 5997996.5112 | 2088343.63565 | 37.7140791860846 | -122.448813929817 | (37.7140791860846, -122.448813929817) | 9 | 7 | 6 | 28861 | 25 | |||
52226 | 213219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 256 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994409.79754 | 2088423.77605 | 37.7140934700115 | -122.461216697819 | (37.7140934700115, -122.461216697819) | 9 | 8 | 6 | 28861 | 24 | |||
140831 | 213229 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993764.50833 | 2088438.47213 | 37.7140966644108 | -122.463448112758 | (37.7140966644108, -122.463448112758) | 9 | 8 | 6 | 64 | 24 | |||
149061 | 213218 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 224 Farallones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994861.70731 | 2088418.2092 | 37.7141041818267 | -122.459654332585 | (37.7141041818267, -122.459654332585) | 9 | 8 | 6 | 28861 | 24 | |||
86123 | 213217 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 224 Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994939.4342 | 2088417.18185 | 37.7141058302824 | -122.459385606161 | (37.7141058302824, -122.459385606161) | 9 | 8 | 6 | 28861 | 24 | |||
55260 | 213230 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993766.05565 | 2088461.67012 | 37.7141604497148 | -122.463444447129 | (37.7141604497148, -122.463444447129) | 9 | 8 | 6 | 64 | 24 | |||
87376 | 1144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2664 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5998083.13925 | 2088389.36469 | 37.7142097010976 | -122.448517802853 | (37.7142097010976, -122.448517802853) | 9 | 7 | 6 | 28861 | 25 | |||
3473 | 58897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/1980 12:00:00 AM | 13 | Permit Number 18169 | 6009836.93544 | 2088163.79838 | 37.7142553893523 | -122.407876041144 | (37.7142553893523, -122.407876041144) | 9 | 7 | 8 | 309 | 39 | ||
172363 | 1141 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2654 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5998128.13088 | 2088414.42879 | 37.7142810937806 | -122.44836409885 | (37.7142810937806, -122.44836409885) | 9 | 7 | 6 | 28861 | 25 | |||
94599 | 76762 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
136219 | 1140 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2650 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5998163.64148 | 2088434.81508 | 37.7143391000469 | -122.448242827952 | (37.7143391000469, -122.448242827952) | 9 | 7 | 6 | 28861 | 25 | |||
176923 | 7668 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2619X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1992 12:00:00 AM | 25 | 3X3 | 5998396.0537 | 2088464.91695 | 37.7144350370294 | -122.447441688494 | (37.7144350370294, -122.447441688494) | 9 | 7 | 6 | 28861 | 25 | ||
127033 | 65707 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 38 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28636 | 6000117.01956544 | 2088450.54737046 | 37.7144937773392 | -122.441492331211 | (37.7144937773392, -122.441492331211) | 9 | 7 | 6 | 28861 | 5 | ||
176112 | 1138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2626 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 15 | 3x3 | 5998272.61977 | 2088495.92363 | 37.7145131197643 | -122.447870554484 | (37.7145131197643, -122.447870554484) | 9 | 7 | 6 | 28861 | 25 | ||
102468 | 217559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991899.9861 | 2088634.5576 | 37.7145274659328 | -122.469906823982 | (37.7145274659328, -122.469906823982) | 9 | 8 | 6 | 64 | 24 | |||
55988 | 217562 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5991901.2136 | 2088641.0019 | 37.7145452313743 | -122.469903050206 | (37.7145452313743, -122.469903050206) | 9 | 8 | 6 | 64 | 24 | |||
18388 | 217560 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5991890.4732 | 2088641.6156 | 37.7145462955922 | -122.469940217678 | (37.7145462955922, -122.469940217678) | 9 | 8 | 6 | 64 | 24 | |||
148376 | 11822 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1299X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | PUC 8 | 10 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
5991 | 217563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991900.5999 | 2088650.2079 | 37.714570473344 | -122.469905841257 | (37.714570473344, -122.469905841257) | 9 | 8 | 6 | 64 | 24 | |||
131199 | 1137 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2614 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5998316.29466 | 2088516.5463 | 37.7145722411917 | -122.447721080858 | (37.7145722411917, -122.447721080858) | 9 | 7 | 6 | 28861 | 25 |
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) );