trees
1,194 rows where qSpecies_id = 50 sorted by rowid descending
This data as json, CSV (advanced)
These facets timed out: Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194421 | 257937 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 430 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | 7 | 9 | 11 | 28852 | 10 | ||
194227 | 228537 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009258.78622 | 2107356.53697 | 37.7669220806253 | -122.411229322595 | (37.7669220806253, -122.411229322595) | 8 | 4 | 7 | 28853 | 19 | |||
194189 | 36058 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
193991 | 52376 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.419314037874 | (37.7454444472056, -122.419314037874) | 2 | 7 | 7 | 28859 | 2 | ||
193942 | 36713 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 34 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39499 | 6006412.25485032 | 2105738.01834436 | 37.7623179565756 | -122.420960109842 | (37.7623179565756, -122.420960109842) | 8 | 4 | 7 | 28859 | 19 | ||
193911 | 229755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.403236063707 | (37.7528043666378, -122.403236063707) | 10 | 4 | 8 | 28859 | 19 | |||
193864 | 256057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39638 | 6004331 | 2099600 | 37.7453468607112 | -122.427721041632 | (37.7453468607112, -122.427721041632) | 2 | 7 | 5 | 63 | 22 | ||
193547 | 37696 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
193199 | 121757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 20 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
192973 | 226428 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006671.33563 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | 2 | 4 | 7 | 28859 | 19 | |||
192737 | 38603 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015358.9468 | 2094230.8253 | 37.7312218531881 | -122.389213037195 | (37.7312218531881, -122.389213037195) | 10 | 3 | 8 | 58 | 1 | |
192647 | 36594 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
192552 | 229802 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 232 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006479.51273 | 2104709.99124 | 37.7594990251845 | -122.420654508118 | (37.7594990251845, -122.420654508118) | 2 | 4 | 7 | 28859 | 19 | |||
192179 | 105743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 410 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 4x4 | Permit Number 771648 | 6002709 | 2109944 | 37.7736571098162 | -122.434068943261 | (37.7736571098162, -122.434068943261) | 15 | 5 | 11 | 29492 | 10 | ||
192061 | 228549 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009550.58062 | 2101412.53302 | 37.7506175499731 | -122.409800431165 | (37.7506175499731, -122.409800431165) | 2 | 4 | 7 | 28859 | 19 | |||
192044 | 35542 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
191516 | 34323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
191365 | 226435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.7551876321062 | -122.419915770819 | (37.7551876321062, -122.419915770819) | 2 | 4 | 7 | 28859 | 19 | |||
191355 | 190722 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2200 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010363.60354 | 2107883.96222 | 37.7684321691431 | -122.407445105823 | (37.7684321691431, -122.407445105823) | 8 | 4 | 8 | 28853 | 19 | |||
191321 | 52004 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1242 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | 3 | Permit Number 48221 | 6012214.20801 | 2102602.19108 | 37.7540330051314 | -122.400672898747 | (37.7540330051314, -122.400672898747) | 10 | 3 | 8 | 28856 | 29 | |
191205 | 226361 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005760.58737 | 2103420.35055 | 37.7559174283599 | -122.423049246236 | (37.7559174283599, -122.423049246236) | 2 | 4 | 5 | 28859 | 19 | |||
191118 | 44013 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
190935 | 49831 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 547@ 20th S Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 9 | Permit Number 46614 | 6013570.32082 | 2104515.66669 | 37.7593625359769 | -122.396117192266 | (37.7593625359769, -122.396117192266) | 10 | 3 | 8 | 28856 | 29 | |
190748 | 229846 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005141.9373 | 2103725.25099 | 37.7567196838778 | -122.425210437638 | (37.7567196838778, -122.425210437638) | 2 | 4 | 5 | 28859 | 19 | |||
190578 | 37674 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3318 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | Permit Number 40071 | 6008076 | 2104474 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | 2 | 4 | 7 | 28859 | 19 | |
189822 | 190711 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 285 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6013779.84023 | 2105755.3163 | 37.7627779983326 | -122.395479414663 | (37.7627779983326, -122.395479414663) | 14 | 3 | 8 | 28856 | 29 | |||
189598 | 121735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
189461 | 34328 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
189452 | 37743 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
189425 | 37050 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 278 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39655 | 6004138.71288838 | 2098700.07455731 | 37.7428649936747 | -122.428321811345 | (37.7428649936747, -122.428321811345) | 2 | 7 | 5 | 63 | 22 | ||
189285 | 32982 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.395135943769 | (37.7592500775456, -122.395135943769) | 10 | 3 | 8 | 28856 | 29 | |
189225 | 36609 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1457 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39460 | 6009593.56099734 | 2100772.83589567 | 37.7488634920028 | -122.409606655966 | (37.7488634920028, -122.409606655966) | 2 | 4 | 7 | 28859 | 19 | ||
189188 | 32942 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 999X Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 13 | Permit Number 37261 | 6015289.11919 | 2103969.28048 | 37.7579577598656 | -122.390134526983 | (37.7579577598656, -122.390134526983) | 10 | 3 | 8 | 28856 | 29 | |
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
188574 | 226773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.7530417058104 | -122.432759865801 | (37.7530417058104, -122.432759865801) | 2 | 4 | 5 | 28862 | 22 | |||
188542 | 37751 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40098 | 6009586.08390989 | 2100908.24074194 | 37.7492348647629 | -122.409642067631 | (37.7492348647629, -122.409642067631) | 2 | 4 | 7 | 28859 | 19 | |||
188143 | 88302 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
187690 | 229759 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | 10 | 4 | 8 | 28859 | 19 | |||
187580 | 219233 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 387 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994164.56547 | 2092392.43636 | 37.7249763432778 | -122.462351978558 | (37.7249763432778, -122.462351978558) | 9 | 8 | 4 | 28861 | 40 | |||
187560 | 117555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007674.4763735 | 2101992.27281083 | 37.7521040666078 | -122.416329227522 | (37.7521040666078, -122.416329227522) | 2 | 4 | 7 | 28859 | 19 | |||
187364 | 67473 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 880 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 6 | Permit Number 30995 | 6012731.18304 | 2103360.24925 | 37.7561432876862 | -122.398938264795 | (37.7561432876862, -122.398938264795) | 10 | 3 | 8 | 28856 | 29 | |
187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
186938 | 43006 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 201 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | ||
186551 | 226785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.7596405020293 | -122.429996893968 | (37.7596405020293, -122.429996893968) | 2 | 4 | 5 | 28862 | 3 | |||
186473 | 106865 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 580 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014062.5 | 2104405.5 | 37.7590874145177 | -122.394407269796 | (37.7590874145177, -122.394407269796) | 10 | 3 | 8 | 28856 | 29 | |||||
186401 | 226422 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3354 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007858.2602 | 2104522.84344 | 37.7590627694542 | -122.415872851461 | (37.7590627694542, -122.415872851461) | 2 | 4 | 7 | 28859 | 19 | |||
186292 | 226801 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | 2 | 4 | 5 | 28862 | 3 | |||
186236 | 226328 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007822.68734 | 2105830.62056 | 37.7626516238081 | -122.416088496301 | (37.7626516238081, -122.416088496301) | 8 | 4 | 7 | 28859 | 19 | |||
186089 | 229821 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 862 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009901.39603 | 2104182.38613 | 37.7582426021438 | -122.40878266838 | (37.7582426021438, -122.40878266838) | 2 | 4 | 7 | 28859 | 19 | |||
185908 | 226777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004194.76383 | 2103338.46367 | 37.7556041027521 | -122.428458541531 | (37.7556041027521, -122.428458541531) | 2 | 4 | 5 | 28862 | 22 | |||
185655 | 74908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
185552 | 26498 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.27107 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | 2 | 4 | 7 | 28859 | 19 | ||
185042 | 32948 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.7623103112918 | -122.398349060474 | (37.7623103112918, -122.398349060474) | 10 | 3 | 8 | 28856 | 29 | ||
185014 | 67355 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 815 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777973 | 6009933.6561998 | 2104468.00986769 | 37.759028667481 | -122.408691247698 | (37.759028667481, -122.408691247698) | 2 | 4 | 7 | 28859 | 19 | |
185009 | 39550 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 815 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40976 | 6012466.96888 | 2104165.36194 | 37.7583392243866 | -122.399908546943 | (37.7583392243866, -122.399908546943) | 10 | 3 | 8 | 28856 | 29 | |
184733 | 33040 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37317 | 6005440.04608192 | 2101847.29088497 | 37.751580078433 | -122.42404592247 | (37.751580078433, -122.42404592247) | 2 | 4 | 5 | 28859 | 19 | ||
184669 | 39568 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963434 | (37.7594620297563, -122.40312963434) | 10 | 3 | 8 | 28856 | 29 | |
184626 | 88048 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1555 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51058 | 6015584.72865 | 2096785.64052 | 37.73824937351 | -122.388610732819 | (37.73824937351, -122.388610732819) | 10 | 3 | 8 | 58 | 1 | |
184588 | 38249 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
184418 | 226786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3894 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003740.86919 | 2104813.89584 | 37.7596295932412 | -122.430133501864 | (37.7596295932412, -122.430133501864) | 2 | 4 | 5 | 28862 | 3 | |||
184316 | 34332 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
183793 | 58933 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.28777 | 37.7528410841477 | -122.401525896729 | (37.7528410841477, -122.401525896729) | 10 | 3 | 8 | 28856 | 29 | ||
183689 | 34745 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2531 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38393 | 6008900.83649709 | 2103723.81151617 | 37.756927366913 | -122.4122106421 | (37.756927366913, -122.4122106421) | 2 | 4 | 7 | 28859 | 19 | ||
183431 | 10960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1430 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2018 12:00:00 AM | 3 | 3X4 | Permit Number 782059 | 6016587.34912 | 2096809.91728 | 37.7383715463994 | -122.385145824822 | (37.7383715463994, -122.385145824822) | 10 | 3 | 8 | 58 | 1 | |
183347 | 68748 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53751 | 6003148.31037661 | 2105371.6272327 | 37.7611274107355 | -122.432222696746 | (37.7611274107355, -122.432222696746) | 15 | 4 | 5 | 28862 | 3 | |
182567 | 34728 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 | ||
181833 | 226412 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1987 12:00:00 AM | 14 | Width 3ft | Permit Number 24387 | 6008267.80034 | 2100190.98708 | 37.7471914863912 | -122.41414999144 | (37.7471914863912, -122.41414999144) | 2 | 7 | 7 | 28859 | 2 | |
181781 | 49967 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3228@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 46719 | 6008983.82935555 | 2099882.83427264 | 37.7463855595114 | -122.411652240395 | (37.7463855595114, -122.411652240395) | 2 | 7 | 7 | 28859 | 2 | ||
181741 | 226453 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008553.18177 | 2102742.64498 | 37.754213792241 | -122.41334358196 | (37.754213792241, -122.41334358196) | 2 | 4 | 7 | 28859 | 19 | |||
181529 | 229746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 6005420.74895 | 2100228.937 | 37.7471353615169 | -122.423997581329 | (37.7471353615169, -122.423997581329) | 2 | 7 | 5 | 28859 | 22 | |||
181262 | 35309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38777 | 6005480.32103823 | 2105501.15439096 | 37.7616150083325 | -122.424166477384 | (37.7616150083325, -122.424166477384) | 8 | 4 | 5 | 28859 | 19 | ||
181243 | 226780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3980 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003123.97049 | 2105369.10011 | 37.7611190917893 | -122.432306697403 | (37.7611190917893, -122.432306697403) | 15 | 4 | 5 | 28862 | 3 | |||
181150 | 226323 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | 2 | 4 | 7 | 28859 | 19 | |||
181125 | 229820 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 709 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009884.4018 | 2104852.89904 | 37.7600827274654 | -122.408888748842 | (37.7600827274654, -122.408888748842) | 2 | 4 | 8 | 28859 | 19 | |||
180841 | 190739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010536.50922 | 2107598.98356 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | 8 | 4 | 8 | 28853 | 19 | |||
180711 | 68479 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1216 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32349 | 6010272.81628211 | 2102122.83184257 | 37.7526083219498 | -122.407352938123 | (37.7526083219498, -122.407352938123) | 2 | 4 | 7 | 28859 | 19 | ||
180344 | 36600 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1426 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39453 | 6009534.63032836 | 2100896.9108508 | 37.7492008719769 | -122.409819196077 | (37.7492008719769, -122.409819196077) | 2 | 4 | 7 | 28859 | 19 | ||
179950 | 32943 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.390145145285 | (37.7581508424957, -122.390145145285) | 10 | 3 | 8 | 28856 | 29 |
179824 | 100088 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003201.40964 | 2118956.65929 | 37.7984315255609 | -122.433009662373 | (37.7984315255609, -122.433009662373) | 13 | 9 | 1 | 57 | 17 | |||
179728 | 34310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
179723 | 226405 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628925 | -122.415012541103 | (37.746498628925, -122.415012541103) | 2 | 7 | 7 | 28859 | 2 | |||
179676 | 38602 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1556 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50557 | 6015367.191 | 2094226.978 | 37.7312117463081 | -122.389184266735 | (37.7312117463081, -122.389184266735) | 10 | 3 | 8 | 58 | 1 | |
179365 | 99928 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298 | 2105556 | 37.7618680647923 | -122.417883738243 | (37.7618680647923, -122.417883738243) | 2 | 4 | 7 | 28859 | 19 |
179328 | 190713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013844.95879 | 2104593.96331 | 37.7595927983841 | -122.395172837551 | (37.7595927983841, -122.395172837551) | 10 | 3 | 8 | 28856 | 29 | |||
178845 | 34366 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | 2 | 7 | 5 | 63 | 7 | ||
178778 | 226424 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007852.84367 | 2104586.25311 | 37.7592365733232 | -122.415896074661 | (37.7592365733232, -122.415896074661) | 2 | 4 | 7 | 28859 | 19 | |||
178334 | 37742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
178217 | 226324 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | 2 | 4 | 7 | 28859 | 19 | |||
177993 | 228536 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | 8 | 4 | 7 | 28853 | 19 | |||
177741 | 226317 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | 2 | 4 | 7 | 28859 | 19 | |||
177270 | 176586 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Seneca Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999824.12192 | 2090353.83878 | 37.7197030929005 | -122.442641276491 | (37.7197030929005, -122.442641276491) | 9 | 7 | 6 | 28861 | 25 | |||
177064 | 44004 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
177009 | 226349 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3169 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008560.82259 | 2101530.27945 | 37.7508853383864 | -122.413231431983 | (37.7508853383864, -122.413231431983) | 2 | 4 | 7 | 28859 | 19 | |||
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
176891 | 190742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.7383078753038 | -122.390378936647 | (37.7383078753038, -122.390378936647) | 10 | 3 | 8 | 58 | 1 | |||
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
176666 | 96068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767693 | 6008044 | 2101787 | 37.7515612062089 | -122.415036827298 | (37.7515612062089, -122.415036827298) | 2 | 4 | 7 | 28859 | 19 | |
176654 | 226367 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.7523360311927 | -122.438680460736 | (37.7523360311927, -122.438680460736) | 2 | 4 | 5 | 28862 | 22 | |||
176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 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) );