Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 24705 | 24705 | 74639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 3 | 6007029.8225 | 2113512.7316900003 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25545 | 25545 | 71820 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 11 | 5988034.0091 | 2106701.9931 | 37.763911677097894 | -122.484593510615 | (37.7639116770979, -122.484593510615) | ||
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 26181 | 26181 | 74488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.50035771523599 | (37.7433893618735, -122.500357715236) | ||
| 29959 | 29959 | 71819 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1226 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 15 | 5988024.8183 | 2106940.9532 | 37.764567260766704 | -122.48464282811001 | (37.7645672607667, -122.48464282811) | ||
| 30206 | 30206 | 70458 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | ||
| 31704 | 31704 | 70357 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3827 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982346.2639999995 | 2104189.8384 | 37.7566811453358 | -122.50407929098 | (37.7566811453358, -122.50407929098) | ||
| 32156 | 32156 | 80704 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3124 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2003 12:00:00 AM | 7 | 5995997.04045 | 2111450.94518 | 37.777411575663706 | -122.457395540163 | (37.7774115756637, -122.457395540163) | ||
| 33176 | 33176 | 78341 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4355 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985136.83686 | 2111755.43817 | 37.7776178597512 | -122.494986455031 | (37.7776178597512, -122.494986455031) | ||
| 33254 | 33254 | 75201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017848.7148 | 2092502.4066 | 37.726613663810795 | -122.380485286019 | (37.7266136638108, -122.380485286019) | ||
| 36833 | 36833 | 78526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 6 | 5981863.3141 | 2099471.5008 | 37.7436975019585 | -122.505399764525 | (37.7436975019585, -122.505399764525) | ||
| 37548 | 37548 | 70361 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3933 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982619.7769 | 2104883.3949 | 37.75860153616 | -122.503184748041 | (37.75860153616, -122.503184748041) | ||
| 41486 | 41486 | 81182 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | ||
| 41830 | 41830 | 73381 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.50376486060101 | (37.7591449348846, -122.503764860601) | ||
| 41888 | 41888 | 72312 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3839 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 5 | 5995843.90542 | 2115819.74251 | 37.7893983291806 | -122.458241562721 | (37.7893983291806, -122.458241562721) | ||
| 42718 | 42718 | 71413 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1207 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 6 | 6016921.2196 | 2093689.4573 | 37.7298218479605 | -122.38377424868 | (37.7298218479605, -122.38377424868) | ||
| 42861 | 42861 | 70362 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | ||
| 42951 | 42951 | 74588 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | ||
| 42956 | 42956 | 71410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1505 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 18 | 6015694.2103 | 2094255.0083 | 37.7313068352663 | -122.38805564796002 | (37.7313068352663, -122.38805564796) | ||
| 45143 | 45143 | 74934 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 747 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 2 | 6007018.6844 | 2113571.6653 | 37.78386144810071 | -122.419418459219 | (37.7838614481007, -122.419418459219) | ||
| 45526 | 45526 | 78080 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2325 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | 5 | 5991427.1833 | 2111980.8839 | 37.7786031021867 | -122.473242680545 | (37.7786031021867, -122.473242680545) | ||
| 46713 | 46713 | 70364 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5982287.6338 | 2104871.478 | 37.758549286455604 | -122.504332547004 | (37.7585492864556, -122.504332547004) | ||
| 47064 | 47064 | 75387 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 6 | 5999425.0368 | 2112388.5534 | 37.7801823052034 | -122.445604458946 | (37.7801823052034, -122.445604458946) | ||
| 47363 | 47363 | 74888 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017884.362000001 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | ||
| 47382 | 47382 | 84587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5981781.9237 | 2098926.9802 | 37.7421976095989 | -122.50564083146999 | (37.7421976095989, -122.50564083147) | |||
| 48457 | 48457 | 80046 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.43778031493099 | (37.7976917657091, -122.437780314931) | ||
| 49712 | 49712 | 78804 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 463 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2000 12:00:00 AM | 5 | 5987773.67277 | 2112847.71573 | 37.780770953663 | -122.48594505901501 | (37.780770953663, -122.485945059015) | ||
| 50983 | 50983 | 74792 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 4 | 6007023.88187 | 2113548.2760900003 | 37.783797519769 | -122.41939881802601 | (37.783797519769, -122.419398818026) | ||
| 53984 | 53984 | 83368 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1129 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | 6011680.56998 | 2103127.21797 | 37.755444836412394 | -122.40255527513 | (37.7554448364124, -122.40255527513) | ||
| 56897 | 56897 | 70367 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1406 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983105.9662 | 2105534.9379 | 37.7604190558161 | -122.50155151240601 | (37.7604190558161, -122.501551512406) | ||
| 58302 | 58302 | 70437 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 8 | 5983020.7059 | 2098971.1879 | 37.742391820222295 | -122.50136084638201 | (37.7423918202223, -122.501360846382) | ||
| 59691 | 59691 | 69869 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.50404752601101 | (37.747904810916, -122.504047526011) | ||
| 60075 | 60075 | 70358 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3833 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982319.9846 | 2104190.4495 | 37.7566812777905 | -122.504170218425 | (37.7566812777905, -122.504170218425) | ||
| 61060 | 61060 | 78524 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981824.7341 | 2099468.7935 | 37.743687798107295 | -122.50553296193998 | (37.7436877981073, -122.50553296194) | ||
| 61839 | 61839 | 72305 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3662 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997266.67895 | 2115407.36737 | 37.7883477098214 | -122.453289170381 | (37.7883477098214, -122.453289170381) | ||
| 63090 | 63090 | 72210 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 355 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 13 | 6011262.404159999 | 2119331.4485400002 | 37.7999145399845 | -122.405142399827 | (37.7999145399845, -122.405142399827) | ||
| 64249 | 64249 | 82454 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2925 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | 7 | 5998033.9539 | 2113051.1833 | 37.7819221967761 | -122.45046461106399 | (37.7819221967761, -122.450464611064) | ||
| 66623 | 66623 | 71329 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 346 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6003746.38005 | 2089169.3485299998 | 37.7166735503194 | -122.42899902418101 | (37.7166735503194, -122.428999024181) | ||
| 67321 | 67321 | 79880 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5981353.9893 | 2102319.4895 | 37.751487294996295 | -122.507372114024 | (37.7514872949963, -122.507372114024) | ||
| 71006 | 71006 | 72386 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 3 | 3x3 | 6012294.64496 | 2118148.60765 | 37.7967243955558 | -122.401487260038 | (37.7967243955558, -122.401487260038) | |
| 72256 | 72256 | 78616 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 240 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6010824.43374 | 2092444.67892 | 37.7260650445568 | -122.40476404244801 | (37.7260650445568, -122.404764042448) | ||
| 75411 | 75411 | 78304 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4355 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 7 | 5985168.7813800005 | 2111757.58069 | 37.7776256124831 | -122.494876107778 | (37.7776256124831, -122.494876107778) | ||
| 83081 | 83081 | 111955 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5987872.34655427 | 2115783.06288074 | 37.78883633031629 | -122.48581921103799 | (37.7888363303163, -122.485819211038) | |||
| 130054 | 130054 | 78806 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 463-473 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2000 12:00:00 AM | 5 | 5987775.75942 | 2112816.18312 | 37.7806844956402 | -122.48593552516701 | (37.7806844956402, -122.485935525167) | ||
| 132672 | 132672 | 69750 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 805 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 10 | 6008877.581730001 | 2090316.9331 | 37.720113693661496 | -122.411343969962 | (37.7201136936615, -122.411343969962) | ||
| 133356 | 133356 | 78173 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1203 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 3 | 5982086.3748 | 2106829.8545 | 37.7639145899835 | -122.50517371769101 | (37.7639145899835, -122.505173717691) | ||
| 134601 | 134601 | 69761 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411001 | (37.7454063146777, -122.50535336411) | ||
| 135760 | 135760 | 78288 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 335 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 7 | 6009671.33901 | 2092844.10016 | 37.7270972531353 | -122.408778404709 | (37.7270972531353, -122.408778404709) | ||
| 138196 | 138196 | 72120 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1986 12:00:00 AM | 13 | 5996351.3207 | 2112939.5041 | 37.7815191079205 | -122.456277632841 | (37.7815191079205, -122.456277632841) | ||
| 147629 | 147629 | 75134 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 13 | 5999276.807999999 | 2112366.556 | 37.780113442326105 | -122.44611566553002 | (37.7801134423261, -122.44611566553) | ||
| 151095 | 151095 | 72105 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3024 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1986 12:00:00 AM | 13 | 5997692.6555 | 2113106.1769 | 37.7820536550082 | -122.451649308253 | (37.7820536550082, -122.451649308253) | ||
| 152504 | 152504 | 71826 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1985 12:00:00 AM | 13 | 5988678.2006 | 2104711.6203 | 37.758484147168495 | -122.48221964019301 | (37.7584841471685, -122.482219640193) | ||
| 152944 | 152944 | 70360 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3826 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982955.4526 | 2104949.3397 | 37.7588023275687 | -122.502028728145 | (37.7588023275687, -122.502028728145) | ||
| 155376 | 155376 | 78523 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981811.5356 | 2099469.1319 | 37.7436879505195 | -122.50557862346201 | (37.7436879505195, -122.505578623462) | ||
| 155459 | 155459 | 71813 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3353 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 13 | 5998192.69497 | 2116144.55888 | 37.7904248748608 | -122.45013847650401 | (37.7904248748608, -122.450138476504) | ||
| 155560 | 155560 | 80088 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2325 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 7 | 6001799.98611 | 2118713.99662 | 37.797685646742394 | -122.43784161989299 | (37.7976856467424, -122.437841619893) | ||
| 155856 | 155856 | 73716 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 946 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 14 | 3x3 | 6012746.538269999 | 2103105.12598 | 37.755443630425795 | -122.39886725612499 | (37.7554436304258, -122.398867256125) | |
| 157037 | 157037 | 78932 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2701 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 5 | 5986398.8011 | 2105011.0057 | 37.7591733303576 | -122.490124736723 | (37.7591733303576, -122.490124736723) | ||
| 158803 | 158803 | 73155 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1539 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2001 12:00:00 AM | 6 | 5984024.4181 | 2104677.685 | 37.758119180402296 | -122.498311745037 | (37.7581191804023, -122.498311745037) | ||
| 159104 | 159104 | 75339 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 288 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1989 12:00:00 AM | 15 | Permit Number 768105 | 6009126.26844 | 2113603.03631 | 37.7840660654432 | -122.41212919142001 | (37.7840660654432, -122.41212919142) | |
| 159989 | 159989 | 71412 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1347 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 14 | 6016206.5271 | 2094219.1986 | 37.731236879718 | -122.38628196303999 | (37.731236879718, -122.38628196304) | ||
| 161681 | 161681 | 78340 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4355 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 7 | 5985152.99367 | 2111756.8586 | 37.7776227056539 | -122.494930668748 | (37.7776227056539, -122.494930668748) | ||
| 161732 | 161732 | 74932 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1494 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 4.5x6 | 5982503.1091 | 2104954.5575 | 37.758790069955396 | -122.503593501173 | (37.7587900699554, -122.503593501173) | |
| 163200 | 163200 | 70250 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | ||
| 163952 | 163952 | 78342 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4355 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985108.45744 | 2111754.27861 | 37.7776130145544 | -122.49508454206001 | (37.7776130145544, -122.49508454206) | ||
| 164282 | 164282 | 78343 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4355 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985091.780590001 | 2111753.3988900003 | 37.7776096227676 | -122.495142167176 | (37.7776096227676, -122.495142167176) | ||
| 167383 | 167383 | 81778 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1206 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/1982 12:00:00 AM | 5 | 5985539.6677 | 2106971.5989 | 37.7645063645382 | -122.493240428332 | (37.7645063645382, -122.493240428332) | ||
| 167743 | 167743 | 72287 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3814 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 5 | 5983731.23615 | 2111080.74705 | 37.7756829689732 | -122.499798944694 | (37.7756829689732, -122.499798944694) | ||
| 167997 | 167997 | 71825 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1555 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1985 12:00:00 AM | 14 | 5988675.2864 | 2104754.3629 | 37.758601337299 | -122.482232850163 | (37.758601337299, -122.482232850163) | ||
| 171791 | 171791 | 72209 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 315 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 10 | 6011420.02502 | 2119355.99811 | 37.7999907575129 | -122.40459869847099 | (37.7999907575129, -122.404598698471) | ||
| 172112 | 172112 | 78507 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 8 | 6010703.64551 | 2092552.9257099999 | 37.726355515673106 | -122.4051892212 | (37.7263555156731, -122.4051892212) | ||
| 178391 | 178391 | 78380 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1027 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 9 | 6x4 | 6003865.37713 | 2089493.15016 | 37.717569374004796 | -122.428610778768 | (37.7175693740048, -122.428610778768) | |
| 178976 | 178976 | 75310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 14 | 5999369.874 | 2112377.7239 | 37.7801494207177 | -122.445794512547 | (37.7801494207177, -122.445794512547) | ||
| 183688 | 183688 | 79638 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1307 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 4 | 5982729.5509 | 2106184.5595 | 37.7621806168968 | -122.502901428306 | (37.7621806168968, -122.502901428306) | ||
| 184500 | 184500 | 71821 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1270 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 13 | 5988034.775 | 2106656.0393 | 37.7637855451579 | -122.484587490638 | (37.7637855451579, -122.484587490638) | ||
| 184695 | 184695 | 75215 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 14 | 5999304.897000001 | 2112369.9402 | 37.7801243384858 | -122.44601873676399 | (37.7801243384858, -122.446018736764) | ||
| 186836 | 186836 | 78525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981839.9629999995 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | ||
| 187231 | 187231 | 71911 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 54 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1989 12:00:00 AM | 12 | 6008864.223730001 | 2112520.0320599996 | 37.781077688412104 | -122.41295917575 | (37.7810776884121, -122.41295917575) | ||
| 187715 | 187715 | 83139 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 4 | 6016637.95414 | 2095483.71733 | 37.7347328669128 | -122.38487848967699 | (37.7347328669128, -122.384878489677) | ||
| 5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
| 32499 | 32499 | 72076 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 229 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 14 | 5989910.70009 | 2113826.30511 | 37.7835821901674 | -122.478623713066 | (37.7835821901674, -122.478623713066) | ||
| 50062 | 50062 | 75146 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6010085.43601 | 2111100.02376 | 37.7772471547732 | -122.408634170555 | (37.7772471547732, -122.408634170555) | ||
| 60497 | 60497 | 75390 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6010035.62368 | 2111155.67227 | 37.77739716259529 | -122.40881041516501 | (37.7773971625953, -122.408810415165) | ||
| 75992 | 75992 | 75228 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6010065.6483 | 2111120.54922 | 37.7773024046157 | -122.408704071262 | (37.7773024046157, -122.408704071262) | ||
| 172460 | 172460 | 75304 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 2 | 6010043.764880001 | 2111144.47071 | 37.7773668617363 | -122.408781461497 | (37.7773668617363, -122.408781461497) | ||
| 50321 | 50321 | 74916 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 20 | 5991352.5470199995 | 2112035.32766 | 37.778748267925295 | -122.473504845805 | (37.7787482679253, -122.473504845805) | ||
| 65608 | 65608 | 73728 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 20 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");