trees
3,247 rows where qSpecies_id = 22 sorted by qLegalStatus_id descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6989 | 109119 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 20563 | 109121 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 21125 | 109116 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 25414 | 109115 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 42158 | 43568 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | |||
| 53747 | 113998 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 1110 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 3 | 3x3 | 6007591 | 2103152 | 37.7552837189859 | -122.416700052453 | (37.7552837189859, -122.416700052453) | 2 | 4 | 7 | 28859 | 19 | ||
| 57202 | 109123 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 89702 | 109120 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 92107 | 109124 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 109575 | 109117 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 126583 | 109122 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 182184 | 109118 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 20 | ||||
| 110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 | |
| 180111 | 256895 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Congo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768867 | 6000183.68977 | 2096091.89275 | 37.7354789553486 | -122.441809987085 | (37.7354789553486, -122.441809987085) | 9 | 7 | 4 | 63 | 40 | |||
| 692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
| 796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
| 1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
| 2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 4169 | 56472 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2014 12:00:00 AM | 3 | Permit Number 773427 | 6010126.92776078 | 2099291.06805198 | 37.7448247552135 | -122.40765780266 | (37.7448247552135, -122.40765780266) | 2 | 7 | 7 | 28859 | 2 | ||
| 4230 | 25991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1821 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 3 | 3X3 | 6013865.62853 | 2096292.13024 | 37.7367988747247 | -122.394520028611 | (37.7367988747247, -122.394520028611) | 10 | 3 | 8 | 58 | 1 | ||
| 5009 | 47117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 111X Kingston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45100 | 6005877.48531462 | 2098254.931079 | 37.7417409646574 | -122.422277993643 | (37.7417409646574, -122.422277993643) | 2 | 7 | 7 | 28859 | 2 |
| 5533 | 59035 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3367 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1980 12:00:00 AM | Permit Number 18327; Original species unknown. Removed and replaced without permit in 2000 | 6005902.92482081 | 2103717.90003873 | 37.7567424611364 | -122.422578138877 | (37.7567424611364, -122.422578138877) | 2 | 4 | 5 | 28859 | 19 | |||
| 6217 | 44045 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | 10 | 7 | 8 | 309 | 39 | |||
| 6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
| 6920 | 32855 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37205 | 6000624.61627289 | 2102511.57259046 | 37.7531309843157 | -122.440745886867 | (37.7531309843157, -122.440745886867) | 2 | 4 | 5 | 28862 | 22 | ||
| 7575 | 221710 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41442 | 6005828.31885 | 2102883.52989 | 37.7544472652446 | -122.422776859587 | (37.7544472652446, -122.422776859587) | 2 | 4 | 5 | 28859 | 19 | |
| 8137 | 84234 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | 11 | 6 | 2 | 55 | 26 | ||
| 8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
| 8720 | 67850 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 485 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769 | 2098756.82734478 | 37.7429413329054 | -122.433177202226 | (37.7429413329054, -122.433177202226) | 2 | 7 | 5 | 63 | 22 | ||
| 9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
| 9306 | 40717 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 360 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41696 | 6008594.61699406 | 2097088.56935412 | 37.7386912826447 | -122.412800580048 | (37.7386912826447, -122.412800580048) | 10 | 7 | 7 | 28859 | 2 | ||
| 9492 | 104107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11217 | 36019 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.7440602847413 | -122.419391331569 | (37.7440602847413, -122.419391331569) | 2 | 7 | 7 | 28859 | 2 | ||
| 11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 11718 | 176523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 4 | Width 2ft | Permit Number 48053 | 6000783.87975 | 2089020.62281 | 37.7160970462187 | -122.439228236006 | (37.7160970462187, -122.439228236006) | 9 | 7 | 6 | 28861 | 5 | |
| 12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 12479 | 66411 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2009 12:00:00 AM | 3x3 | Permit Number 52018 | 6006829.83812508 | 2097883.34846014 | 37.7407743554357 | -122.418958717737 | (37.7407743554357, -122.418958717737) | 2 | 7 | 7 | 28859 | 2 | ||
| 12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
| 15326 | 30913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | ||
| 15866 | 87230 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
| 15898 | 36871 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 15922 | 62857 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.7405151705193 | -122.412571078994 | (37.7405151705193, -122.412571078994) | 10 | 7 | 7 | 28859 | 2 | ||
| 16322 | 41156 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
| 16336 | 36872 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 16377 | 94114 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 16653 | 156578 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 327 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782340 | 6006945.39069 | 2096312.28481 | 37.7364670691931 | -122.41844780742 | (37.7364670691931, -122.41844780742) | 2 | 7 | 7 | 28859 | 2 | |
| 17318 | 39391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 17433 | 36873 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 17481 | 52506 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | 9 | 7 | 6 | 28861 | 25 | ||
| 17856 | 68790 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | 1 | 8 | 4 | 29491 | 40 | ||
| 19265 | 44239 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
| 19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
| 19891 | 61244 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3974 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21116 | 6003854.92098549 | 2104240.14481817 | 37.7580606684354 | -122.429698131841 | (37.7580606684354, -122.429698131841) | 2 | 4 | 5 | 28862 | 3 | ||
| 20200 | 109784 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 20649 | 87351 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3374 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | Permit Number 50337 | 5998108 | 2116175 | 37.7905036111085 | -122.450433709576 | (37.7905036111085, -122.450433709576) | 13 | 6 | 1 | 54 | 31 | |||
| 21146 | 94291 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 21207 | 33596 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.419182553853 | (37.7407413706298, -122.419182553853) | 2 | 7 | 7 | 28859 | 2 | ||
| 21252 | 97555 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2011 12:00:00 AM | 3x3 | Permit Number 768266 | 6004805.6 | 2102240.4 | 37.7526236239085 | -122.42626790325 | (37.7526236239085, -122.42626790325) | 2 | 4 | 5 | 28862 | 22 | ||
| 21646 | 44771 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
| 22441 | 35507 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | 2 | 4 | 5 | 28859 | 19 | ||
| 22665 | 67038 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1994 12:00:00 AM | Permit Number 30414 | 6004243.51306572 | 2101045.11693078 | 37.7493098678885 | -122.4281265241 | (37.7493098678885, -122.4281265241) | 2 | 4 | 5 | 28862 | 22 | ||
| 22948 | 63826 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24514 | 6008974.10291824 | 2096930.94751017 | 37.7382797803205 | -122.411477359627 | (37.7382797803205, -122.411477359627) | 10 | 7 | 7 | 28859 | 2 | ||
| 23050 | 63859 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24560 | 6002112.91730611 | 2110421.71062272 | 37.7749349366141 | -122.436165074208 | (37.7749349366141, -122.436165074208) | 15 | 5 | 11 | 29492 | 10 | ||
| 23454 | 63811 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 397 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24498 | 6008814.87080902 | 2096945.70760042 | 37.7383113756234 | -122.41202895062 | (37.7383113756234, -122.41202895062) | 10 | 7 | 7 | 28859 | 2 | ||
| 23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
| 24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
| 24663 | 92015 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2009 12:00:00 AM | 3x3 | Permit Number 52164 | 5998485.7 | 2104379.6 | 37.7581380835524 | -122.448277156413 | (37.7581380835524, -122.448277156413) | 15 | 5 | 5 | 28862 | 12 | ||
| 24939 | 37321 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41123 | 6003410.55922166 | 2103870.78228446 | 37.7570213149701 | -122.431208559798 | (37.7570213149701, -122.431208559798) | 2 | 4 | 5 | 28862 | 3 | ||
| 25123 | 50152 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.7890845068427 | -122.3948355307 | (37.7890845068427, -122.3948355307) | 6 | 2 | 9 | 28855 | 6 | |||
| 25287 | 48366 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
| 26633 | 88961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 583 Shotwell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2008 12:00:00 AM | 3x3 | Permit Number 51727 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | |||
| 26808 | 89205 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 662 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51833 | 5988199 | 2111465.2 | 37.7769997309607 | -122.48437223608 | (37.7769997309607, -122.48437223608) | 11 | 6 | 2 | 55 | 26 | |||
| 27248 | 42307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42530 | 5998732.16654968 | 2093631.30703212 | 37.7286399521282 | -122.446651448677 | (37.7286399521282, -122.446651448677) | 9 | 7 | 4 | 28861 | 40 | ||
| 27284 | 32001 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.7204249107717 | -122.426052988126 | (37.7204249107717, -122.426052988126) | 9 | 7 | 6 | 28861 | 5 | ||
| 27288 | 33750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 845 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38932 | 6005705.24449579 | 2104057.07564242 | 37.7576626039009 | -122.42328590054 | (37.7576626039009, -122.42328590054) | 2 | 4 | 5 | 28859 | 19 | ||
| 27585 | 47159 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52542 | 5992116.68521556 | 2095408.98560737 | 37.7331409014555 | -122.469650709796 | (37.7331409014555, -122.469650709796) | 9 | 8 | 4 | 59 | 40 | ||
| 27607 | 91318 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 28328 | 45196 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | 2 | 4 | 5 | 28859 | 19 | ||
| 28883 | 34868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.7365671542892 | -122.430202896046 | (37.7365671542892, -122.430202896046) | 2 | 7 | 5 | 63 | 7 | ||
| 28893 | 68505 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1957 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32383 | 5992830.56457156 | 2102309.10574943 | 37.752128116881 | -122.467684306461 | (37.752128116881, -122.467684306461) | 1 | 8 | 4 | 29491 | 12 | ||
| 29173 | 98963 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 29390 | 92527 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 29415 | 108948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) | 9 | 7 | 6 | 28861 | 5 |
| 29797 | 61370 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1984 12:00:00 AM | Permit Number 21280 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||
| 29912 | 55609 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 142 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/1972 12:00:00 AM | 1 | Permit Number 11586 | 5992448.32925563 | 2114520.13069232 | 37.7856342525233 | -122.469895103767 | (37.7856342525233, -122.469895103767) | 11 | 6 | 2 | 54 | 11 | ||
| 29930 | 39397 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 30897 | 64364 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | 3 | 1 | 10 | 308 | 23 | ||
| 31594 | 54908 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 10774 | 5997625.73992568 | 2107028.28129343 | 37.7653614921753 | -122.451442291891 | (37.7653614921753, -122.451442291891) | 15 | 5 | 11 | 29492 | 9 | ||
| 31615 | 121559 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
| 32171 | 97541 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32392 | 52630 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2006 12:00:00 AM | 3 | 1.5x1.5 | Permit Number 48715 | 6008580.19743583 | 2096927.02962896 | 37.7382469204577 | -122.412839018524 | (37.7382469204577, -122.412839018524) | 10 | 7 | 7 | 28859 | 2 |
| 32736 | 30601 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 |
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) );