trees
8,758 rows where qSpecies_id = 16 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13515 | 35181 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13604 | 247998 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 346 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 17 | 6009778.5557 | 2099261.40313 | 37.7447237943804 | -122.408860320375 | (37.7447237943804, -122.408860320375) | 2 | 7 | 7 | 28859 | 2 | ||||
13612 | 56875 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2833 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1974 12:00:00 AM | 10 | Permit Number 14111 | 5985174.6991 | 2102919.4422 | 37.7533589143678 | -122.494204043892 | (37.7533589143678, -122.494204043892) | 1 | 8 | 3 | 56 | 35 | ||
13710 | 41219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41927 | 6001924.51424 | 2120048.48598 | 37.8013568843691 | -122.437506333775 | (37.8013568843691, -122.437506333775) | 13 | 9 | 1 | 57 | 17 | |
13722 | 72210 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 355 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6011262.40416 | 2119331.44854 | 37.7999145399845 | -122.405142399827 | (37.7999145399845, -122.405142399827) | 3 | 1 | 10 | 308 | 23 | |||
13752 | 38739 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
13760 | 74588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | 10 | 3 | 8 | 58 | 1 | |||
13790 | 35470 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 7 | Permit Number 38887 | 6007482.79504 | 2112627.10573 | 37.7812940455214 | -122.417745830826 | (37.7812940455214, -122.417745830826) | 7 | 9 | 9 | 28852 | 36 | ||
13791 | 47886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | 1 | 8 | 3 | 56 | 35 | |
13964 | 42655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2535 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42692 | 5983937.5442 | 2098094.9316 | 37.7400396597472 | -122.498126046785 | (37.7400396597472, -122.498126046785) | 1 | 8 | 3 | 29491 | 35 | |
14078 | 78524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981824.7341 | 2099468.7935 | 37.7436877981073 | -122.50553296194 | (37.7436877981073, -122.50553296194) | 1 | 8 | 3 | 29491 | 35 | |||
14348 | 31622 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.470141233061 | (37.7432371814309, -122.470141233061) | 1 | 8 | 4 | 29491 | 40 | ||
14397 | 58813 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | 10 | Permit Number 25136 | 5989578.4419 | 2106919.1252 | 37.7645976827024 | -122.479267726224 | (37.7645976827024, -122.479267726224) | 1 | 8 | 3 | 56 | 35 | ||
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 | |||||
14477 | 60391 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1466 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19971 | 6015630.4552 | 2094729.0488 | 37.7326049228687 | -122.388309135448 | (37.7326049228687, -122.388309135448) | 10 | 3 | 8 | 58 | 1 | |
14487 | 79638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1307 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982729.5509 | 2106184.5595 | 37.7621806168968 | -122.502901428306 | (37.7621806168968, -122.502901428306) | 1 | 8 | 3 | 56 | 35 | |||
14564 | 75201 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017848.7148 | 2092502.4066 | 37.7266136638108 | -122.380485286019 | (37.7266136638108, -122.380485286019) | 10 | 3 | 8 | 58 | 1 | |||
14630 | 78288 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 335 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009671.33901 | 2092844.10016 | 37.7270972531353 | -122.408778404709 | (37.7270972531353, -122.408778404709) | 10 | 3 | 7 | 309 | 28 | |||
14646 | 78342 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985108.45744 | 2111754.27861 | 37.7776130145544 | -122.49508454206 | (37.7776130145544, -122.49508454206) | 11 | 6 | 2 | 55 | 26 | |||
14756 | 82454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2925 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5998033.9539 | 2113051.1833 | 37.7819221967761 | -122.450464611064 | (37.7819221967761, -122.450464611064) | 15 | 6 | 2 | 54 | 16 | |||
14889 | 35207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
14975 | 193793 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 25th St | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6014229.14205 | 2101967.67513 | 37.7524029335523 | -122.393660311891 | (37.7524029335523, -122.393660311891) | 10 | 3 | 8 | 28856 | 1 | ||||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15028 | 49561 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1081@ JONES Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 6 | Permit Number 46450 | 6008771.04283 | 2115931.16008 | 37.7904385922178 | -122.413522859998 | (37.7904385922178, -122.413522859998) | 5 | 1 | 10 | 28858 | 21 | ||
15082 | 75215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999304.897 | 2112369.9402 | 37.7801243384858 | -122.446018736764 | (37.7801243384858, -122.446018736764) | 15 | 5 | 1 | 54 | 16 | |||
15307 | 14419 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 7 | Median : Cutout | Tree | DPW 1 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | 15 | 5 | 2 | 54 | 16 | ||||
15379 | 71911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 54 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008864.22373 | 2112520.03206 | 37.7810776884121 | -122.41295917575 | (37.7810776884121, -122.41295917575) | 7 | 10 | 9 | 28852 | 36 | |||
15412 | 41620 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 7 | Permit Number 44542 | 6011764.26407 | 2099627.4064 | 37.7458397873891 | -122.402019808872 | (37.7458397873891, -122.402019808872) | 10 | 3 | 8 | 58 | 1 | |
15416 | 94973 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 5 | Sidewalk: Curb side : | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | |||
15532 | 78806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 463-473 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987775.75942 | 2112816.18312 | 37.7806844956402 | -122.485935525167 | (37.7806844956402, -122.485935525167) | 11 | 6 | 2 | 55 | 26 | |||
15595 | 69040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1477 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 6 | Permit Number 33047 | 5984317.8775 | 2105128.1273 | 37.7593731725357 | -122.497330103941 | (37.7593731725357, -122.497330103941) | 1 | 8 | 3 | 56 | 35 | |
15683 | 69869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.504047526011 | (37.747904810916, -122.504047526011) | 1 | 8 | 3 | 29491 | 35 | |||
15754 | 35209 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
15758 | 260531 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
15855 | 73381 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.503764860601 | (37.7591449348846, -122.503764860601) | 1 | 8 | 3 | 56 | 35 | |||
16061 | 69750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 805 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008877.58173 | 2090316.9331 | 37.7201136936615 | -122.411343969962 | (37.7201136936615, -122.411343969962) | 9 | 3 | 7 | 309 | 28 | |||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
16228 | 70437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983020.7059 | 2098971.1879 | 37.7423918202223 | -122.501360846382 | (37.7423918202223, -122.501360846382) | 1 | 8 | 3 | 29491 | 35 | |||
16270 | 35178 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16296 | 60403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1547 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 11 | Permit Number 19984 | 6015505.1437 | 2094394.6098 | 37.7316796762211 | -122.388719033204 | (37.7316796762211, -122.388719033204) | 10 | 3 | 8 | 58 | 1 | |
16381 | 60365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1411 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19943 | 6015862.9412 | 2094478.9752 | 37.7319311503682 | -122.387487927897 | (37.7319311503682, -122.387487927897) | 10 | 3 | 8 | 58 | 1 | |
16384 | 59855 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19312 | 6017044.3327 | 2093602.6185 | 37.7295902103514 | -122.383342586023 | (37.7295902103514, -122.383342586023) | 10 | 3 | 8 | 58 | 1 | |
16433 | 60383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1390 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 17 | Permit Number 19963 | 6016068.2256 | 2094403.79893 | 37.7317360992349 | -122.386772969112 | (37.7317360992349, -122.386772969112) | 10 | 3 | 8 | 58 | 1 | |
16636 | 35198 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16694 | 60378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1290 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19958 | 6016574.72071 | 2094023.91948 | 37.7307210551112 | -122.384995439293 | (37.7307210551112, -122.384995439293) | 10 | 3 | 8 | 58 | 1 | |
16792 | 60213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3696 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1982 12:00:00 AM | 8 | Permit Number 19761 | 5997243.01676 | 2115403.58438 | 37.788335966472 | -122.453370764049 | (37.788335966472, -122.453370764049) | 11 | 6 | 1 | 54 | 31 | |
17016 | 70361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3933 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982619.7769 | 2104883.3949 | 37.75860153616 | -122.503184748041 | (37.75860153616, -122.503184748041) | 1 | 8 | 3 | 56 | 35 | |||
17110 | 35180 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
17167 | 60246 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1222 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19798 | 5988024.8183 | 2106962.3984 | 37.7646261434011 | -122.484644401305 | (37.7646261434011, -122.484644401305) | 1 | 8 | 3 | 56 | 35 | |
17170 | 60049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1454 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 10 | Permit Number 19547 | 5988386.7121 | 2105421.5595 | 37.7604164887691 | -122.483279765834 | (37.7604164887691, -122.483279765834) | 1 | 8 | 3 | 56 | 35 | |
17217 | 56867 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2721 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1974 12:00:00 AM | 16 | Permit Number 14102 | 5985533.0017 | 2102928.4495 | 37.7534046064035 | -122.492965639906 | (37.7534046064035, -122.492965639906) | 1 | 8 | 3 | 56 | 35 | ||
17305 | 70367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1406 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983105.9662 | 2105534.9379 | 37.7604190558161 | -122.501551512406 | (37.7604190558161, -122.501551512406) | 1 | 8 | 3 | 56 | 35 | |||
17342 | 60242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1265 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19794 | 5987988.4382 | 2106697.0148 | 37.7638953541046 | -122.4847507595 | (37.7638953541046, -122.4847507595) | 1 | 8 | 3 | 56 | 35 | |
17377 | 260517 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4711x Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
17442 | 70357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3827 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982346.264 | 2104189.8384 | 37.7566811453358 | -122.50407929098 | (37.7566811453358, -122.50407929098) | 1 | 8 | 3 | 56 | 35 | |||
17478 | 63127 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23641 | 6007142.25261762 | 2099206.716095 | 37.7444256145798 | -122.417972293386 | (37.7444256145798, -122.417972293386) | 2 | 7 | 7 | 28859 | 2 | ||
17493 | 60366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1415 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19944 | 6015838.2087 | 2094497.6621 | 37.7319810909702 | -122.387574737396 | (37.7319810909702, -122.387574737396) | 10 | 3 | 8 | 58 | 1 | |
17672 | 60374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1481 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 8 | Permit Number 19952 | 6015496.3499 | 2094754.331 | 37.7326669109096 | -122.388774538468 | (37.7326669109096, -122.388774538468) | 10 | 3 | 8 | 58 | 1 | |
17732 | 60251 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19803 | 5988034.0091 | 2106629.2329 | 37.7637118975254 | -122.484588173208 | (37.7637118975254, -122.484588173208) | 1 | 8 | 3 | 56 | 35 | |
18048 | 65381 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28220 | 6002894.34922795 | 2096164.85673792 | 37.7358333797031 | -122.432443432913 | (37.7358333797031, -122.432443432913) | 2 | 7 | 5 | 63 | 7 | ||
18071 | 74888 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017884.362 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | 10 | 3 | 8 | 58 | 1 | |||
18092 | 78341 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985136.83686 | 2111755.43817 | 37.7776178597512 | -122.494986455031 | (37.7776178597512, -122.494986455031) | 11 | 6 | 2 | 55 | 26 | |||
18187 | 35206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18218 | 60886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 843 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 13 | Permit Number 20670 | 6008888.08032 | 2119703.02395 | 37.8008017733536 | -122.413384775392 | (37.8008017733536, -122.413384775392) | 3 | 1 | 10 | 308 | 32 | |
18230 | 35204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18409 | 41619 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 6 | Permit Number 44542 | 6011782.21791 | 2099613.94885 | 37.7458038378927 | -122.401956780795 | (37.7458038378927, -122.401956780795) | 10 | 3 | 8 | 58 | 1 | |
18742 | 60351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1151 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19929 | 6017264.1776 | 2093436.6356 | 37.7291466011683 | -122.382571007193 | (37.7291466011683, -122.382571007193) | 10 | 3 | 8 | 58 | 1 | |
18754 | 76692 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6010109 | 2093148 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | 10 | 3 | 7 | 309 | 28 | |||
18783 | 69008 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2118 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 6 | Permit Number 33010 | 5982340.9965 | 2100665.9606 | 37.747005255456 | -122.503836528192 | (37.747005255456, -122.503836528192) | 1 | 8 | 3 | 29491 | 35 | |
18788 | 61569 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 958 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 12 | Permit Number 21529 | 6012748.7696 | 2103051.87566 | 37.7552975409755 | -122.398855802363 | (37.7552975409755, -122.398855802363) | 10 | 3 | 8 | 28856 | 29 | |
18828 | 60398 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19979 | 6015809.7578 | 2094169.3658 | 37.7310780791324 | -122.387650202586 | (37.7310780791324, -122.387650202586) | 10 | 3 | 8 | 58 | 1 | |
18846 | 60396 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1437 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19976 | 6016099.8399 | 2093952.5449 | 37.7304987959412 | -122.386632216078 | (37.7304987959412, -122.386632216078) | 10 | 3 | 8 | 58 | 1 | |
18875 | 46976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44996 | |||||||||||||
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 | |
18969 | 78173 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1203 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982086.3748 | 2106829.8545 | 37.7639145899835 | -122.505173717691 | (37.7639145899835, -122.505173717691) | 1 | 8 | 3 | 56 | 35 | |||
18987 | 78932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5986398.8011 | 2105011.0057 | 37.7591733303576 | -122.490124736723 | (37.7591733303576, -122.490124736723) | 1 | 8 | 3 | 56 | 35 | |||
19011 | 78080 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5991427.1833 | 2111980.8839 | 37.7786031021867 | -122.473242680545 | (37.7786031021867, -122.473242680545) | 11 | 6 | 2 | 54 | 26 | |||
19139 | 78343 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985091.78059 | 2111753.39889 | 37.7776096227676 | -122.495142167176 | (37.7776096227676, -122.495142167176) | 11 | 6 | 2 | 55 | 26 | |||
19269 | 59844 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19299 | 6016800.8545 | 2093779.0441 | 37.7300611813825 | -122.384196605056 | (37.7300611813825, -122.384196605056) | 10 | 3 | 8 | 58 | 1 | |
19325 | 55119 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/1972 12:00:00 AM | 16 | Permit Number 11021 | 5997096.40798246 | 2105960.18380068 | 37.7623984432414 | -122.45319600432 | (37.7623984432414, -122.45319600432) | 15 | 5 | 11 | 29492 | 12 | ||
19347 | 43056 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2183 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981689.1961 | 2100235.8265 | 37.7457858798003 | -122.506058471243 | (37.7457858798003, -122.506058471243) | 1 | 8 | 3 | 29491 | 35 | |
19571 | 71819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1226 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5988024.8183 | 2106940.9532 | 37.7645672607667 | -122.48464282811 | (37.7645672607667, -122.48464282811) | 1 | 8 | 3 | 56 | 35 | |||
19626 | 70360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3826 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982955.4526 | 2104949.3397 | 37.7588023275687 | -122.502028728145 | (37.7588023275687, -122.502028728145) | 1 | 8 | 3 | 56 | 35 | |||
19855 | 44060 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 261 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43587 | 6006383.26807 | 2086331.02129 | 37.7090290107549 | -122.419683323929 | (37.7090290107549, -122.419683323929) | 9 | 7 | 8 | 309 | 39 | ||
20041 | 97746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
20068 | 59210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 655 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21769 | 6004452.7032449 | 2107745.67004762 | 37.7677198351136 | -122.427880529994 | (37.7677198351136, -122.427880529994) | 8 | 4 | 5 | 28862 | 3 | ||
20158 | 64031 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2328 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24788 | 6002100.67136952 | 2107083.49233192 | 37.7657683190956 | -122.435968519546 | (37.7657683190956, -122.435968519546) | 15 | 5 | 5 | 28862 | 3 | ||
20443 | 94864 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987748.3 | 2115456.9 | 37.7879335515465 | -122.486224435532 | (37.7879335515465, -122.486224435532) | 11 | 6 | 1 | 55 | 33 | |||||
20520 | 66318 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 158 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1994 12:00:00 AM | Permit Number 29435 | 6001030.24418552 | 2094968.77102458 | 37.7324433243511 | -122.438802679239 | (37.7324433243511, -122.438802679239) | 9 | 7 | 5 | 63 | 40 | ||
20648 | 38458 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21049 | 101118 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 17026 | 5990136.9434 | 2103098.5473 | 37.7541398185385 | -122.477056838029 | (37.7541398185385, -122.477056838029) | 1 | 8 | 3 | 56 | 35 | |||
21204 | 56719 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6015682.1188 | 2095740.885 | 37.7353860836846 | -122.388201110466 | (37.7353860836846, -122.388201110466) | 10 | 3 | 8 | 58 | 1 | ||||
21337 | 67795 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4518 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31438 | 6000923.92278491 | 2101155.09439533 | 37.7494234620324 | -122.439613590872 | (37.7494234620324, -122.439613590872) | 2 | 4 | 5 | 28862 | 22 | ||
21452 | 31441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4043 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 11 | Permit Number 35016 | 6002890.87661 | 2102383.92626 | 37.7529092986281 | -122.432899597933 | (37.7529092986281, -122.432899597933) | 2 | 4 | 5 | 28862 | 22 | |
21468 | 56542 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1633 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 5989871.3069 | 2101728.7521 | 37.7503633087611 | -122.47787533425 | (37.7503633087611, -122.47787533425) | 1 | 8 | 3 | 29491 | 35 | ||||
21614 | 38755 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 133 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | 6 | 2 | 9 | 28856 | 34 | |||
21654 | 177726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989405.70354 | 2089245.56508 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | 1 | 8 | 4 | 64 | 14 | ||||
21938 | 60941 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1321 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20744 | 5990787.68033218 | 2105162.79852462 | 37.7598454365266 | -122.474957124226 | (37.7598454365266, -122.474957124226) | 1 | 8 | 4 | 56 | 12 | ||
21973 | 37095 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1434 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | Permit Number 39695 | 5981563.3022 | 2105312.3785 | 37.7597172453626 | -122.506870271465 | (37.7597172453626, -122.506870271465) | 1 | 8 | 3 | 56 | 35 |
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) );