trees
1,194 rows where qSpecies_id = 50 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157743 | 38250 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | 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 | ||
157538 | 37735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | |||
157433 | 176584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 263 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5997986.0041 | 2088216.93337 | 37.7137306897928 | -122.448841125323 | (37.7137306897928, -122.448841125323) | 9 | 7 | 6 | 28861 | 25 | |||
157398 | 121753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 16 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
157299 | 226765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | 2 | 7 | 5 | 28861 | 25 | |||
157178 | 229840 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508 | (37.7583780804987, -122.42428471508) | 2 | 4 | 5 | 28859 | 19 | |||
157158 | 121746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 9 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
156928 | 34731 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
156800 | 10139 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.71608 | 37.7566603214356 | -122.42320418504 | (37.7566603214356, -122.42320418504) | 2 | 4 | 5 | 28859 | 19 | ||
156574 | 226370 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.436090732519 | (37.7499246016413, -122.436090732519) | 2 | 4 | 5 | 28862 | 22 | |||
156536 | 68108 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31854 | 6008265.27071667 | 2099541.297285 | 37.7454074408153 | -122.414112782506 | (37.7454074408153, -122.414112782506) | 2 | 7 | 7 | 28859 | 2 | ||
156427 | 229873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3571 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004534.15788 | 2103646.15858 | 37.7564681605797 | -122.427306727641 | (37.7564681605797, -122.427306727641) | 2 | 4 | 5 | 28862 | 22 | |||
156367 | 94883 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53950 | 6014292.7 | 2095395.8 | 37.7343614687147 | -122.392980749985 | (37.7343614687147, -122.392980749985) | 10 | 3 | 8 | 58 | 1 | ||
156260 | 40004 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | 10 | 3 | 8 | 58 | 1 | |
156239 | 35551 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
156163 | 190734 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | 8 | 4 | 8 | 28853 | 19 | |||
156109 | 34315 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 25 | 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 | ||||
156084 | 226351 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3273 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006624.34034 | 2103173.55504 | 37.7552884883831 | -122.420044586082 | (37.7552884883831, -122.420044586082) | 2 | 4 | 7 | 28859 | 19 | |||
156039 | 226426 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3323 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006880.3188 | 2102604.06002 | 37.7537392047139 | -122.419118940914 | (37.7537392047139, -122.419118940914) | 2 | 4 | 7 | 28859 | 19 | |||
156001 | 226798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3992 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003742.96223 | 2104233.19003 | 37.7580352319537 | -122.430084836864 | (37.7580352319537, -122.430084836864) | 2 | 4 | 5 | 28862 | 3 | |||
155526 | 226784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003023.04842 | 2105091.71244 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | 2 | 4 | 5 | 28862 | 3 | |||
155492 | 38276 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.7578642888268 | -122.394852504434 | (37.7578642888268, -122.394852504434) | 10 | 3 | 8 | 28856 | 29 | ||
155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
155445 | 28065 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2576 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 12 | 3X3 | 6009719.04611 | 2102350.04498 | 37.7532011888856 | -122.409284012572 | (37.7532011888856, -122.409284012572) | 2 | 4 | 7 | 28859 | 19 | ||
155304 | 33026 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
154980 | 29076 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009690.9471404 | 2103965.2718708 | 37.7576346655719 | -122.409495172566 | (37.7576346655719, -122.409495172566) | 2 | 4 | 7 | 28859 | 19 | ||
154582 | 229782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011435.78224 | 2102697.98371 | 37.7542525844934 | -122.403371635592 | (37.7542525844934, -122.403371635592) | 10 | 4 | 8 | 28859 | 19 | |||
154249 | 228539 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.7669118166657 | -122.411388369502 | (37.7669118166657, -122.411388369502) | 8 | 4 | 7 | 28853 | 19 | |||
154193 | 117396 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | 2 | 7 | 7 | 28859 | 2 | ||
153942 | 34730 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
153879 | 39493 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40951 | 6004185.70363157 | 2100750.04388013 | 37.7484963949206 | -122.428305402815 | (37.7484963949206, -122.428305402815) | 2 | 4 | 5 | 28862 | 22 | ||
153794 | 190695 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013444.76571 | 2106699.32295 | 37.7653513894931 | -122.396704508917 | (37.7653513894931, -122.396704508917) | 14 | 3 | 8 | 28856 | 20 | |||
153755 | 226788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.7602161904576 | -122.43597676864 | (37.7602161904576, -122.43597676864) | 2 | 4 | 5 | 28862 | 3 | |||
153478 | 37047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.7430807339727 | -122.424735348964 | (37.7430807339727, -122.424735348964) | 2 | 7 | 5 | 63 | 22 | ||
153280 | 226762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005544.98011 | 2099653.84342 | 37.7455632989187 | -122.423527119901 | (37.7455632989187, -122.423527119901) | 2 | 7 | 5 | 28859 | 22 | |||
153024 | 105745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771651 | 6002705 | 2109971 | 37.7737310181147 | -122.434084710333 | (37.7737310181147, -122.434084710333) | 15 | 5 | 11 | 29492 | 10 | |
153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
152666 | 32965 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 11 | 7x6 | Permit Number 37280 | 6014071.41137 | 2104533.66356 | 37.7594398192185 | -122.394385423553 | (37.7594398192185, -122.394385423553) | 10 | 3 | 8 | 28856 | 29 |
152582 | 41339 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 791 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 8 | Permit Number 41992 | 6002462.02491535 | 2103606.38445454 | 37.7562415435961 | -122.434470043403 | (37.7562415435961, -122.434470043403) | 2 | 4 | 5 | 28862 | 3 | ||
152448 | 40005 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | 10 | 3 | 8 | 58 | 1 | ||
152400 | 37698 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 2 | 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 | ||
152160 | 229736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009548.10461 | 2100752.4115 | 37.7488048638556 | -122.409762403312 | (37.7488048638556, -122.409762403312) | 2 | 4 | 7 | 28859 | 19 | |||
152140 | 200047 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1582 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015033.0267 | 2094124.7502 | 37.7309125188233 | -122.390332402249 | (37.7309125188233, -122.390332402249) | 10 | 3 | 8 | 58 | 1 | |||
152066 | 121728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
151810 | 226467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 11 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726947 | (37.7455007798334, -122.42261726947) | 2 | 7 | 5 | 28859 | 22 | |||
151786 | 121754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 17 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
151047 | 190732 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.7679851656226 | -122.406867209579 | (37.7679851656226, -122.406867209579) | 8 | 4 | 8 | 28853 | 19 | |||
150983 | 229845 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005155.25082 | 2103726.26853 | 37.756723229919 | -122.425164466987 | (37.756723229919, -122.425164466987) | 2 | 4 | 5 | 28859 | 19 | |||
150448 | 46555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
150369 | 37965 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40196 | 6013488.00942657 | 2104993.46196391 | 37.7606698772605 | -122.396435357808 | (37.7606698772605, -122.396435357808) | 10 | 3 | 8 | 28856 | 29 | ||
150302 | 34324 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 | 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 | ||||
150230 | 37662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
149993 | 88471 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1525 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015740.82967 | 2096670.14534 | 37.7379408970519 | -122.388062950362 | (37.7379408970519, -122.388062950362) | 10 | 3 | 8 | 58 | 1 | |
149748 | 226387 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | 2 | 7 | 7 | 28859 | 2 | |||
149430 | 190733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010530.15081 | 2107694.73579 | 37.767921917195 | -122.406855692832 | (37.767921917195, -122.406855692832) | 8 | 4 | 8 | 28853 | 19 | |||
149185 | 36051 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 11 | 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 | |||
149172 | 69228 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 537 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 12 | 7x7 | Permit Number 33281 | 6005209.5873 | 2111278.8914 | 37.7774639950364 | -122.425514041455 | (37.7774639950364, -122.425514041455) | 7 | 9 | 11 | 28852 | 10 |
149126 | 38643 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.398977968961 | (37.7565441236392, -122.398977968961) | 10 | 3 | 8 | 28856 | 29 | |
149017 | 226776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 16 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6004065.40509 | 2102868.59003 | 37.7543066193819 | -122.428872407741 | (37.7543066193819, -122.428872407741) | 2 | 4 | 5 | 28862 | 22 | |||
148478 | 34331 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 9 | 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 | ||||
148309 | 226304 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008016.14912 | 2099877.20359 | 37.7463157688762 | -122.414997978399 | (37.7463157688762, -122.414997978399) | 2 | 7 | 7 | 28859 | 2 | |||
148052 | 229872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004865.55222 | 2102495.62663 | 37.7533278053416 | -122.426078745663 | (37.7533278053416, -122.426078745663) | 2 | 4 | 5 | 28862 | 22 | |||
147729 | 54450 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51720 | 6011224.5432 | 2106327.02843 | 37.7642053321404 | -122.40435757586 | (37.7642053321404, -122.40435757586) | 8 | 3 | 8 | 28856 | 29 | |
147709 | 110368 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | 8 | 4 | 8 | 28853 | 19 | |||
147463 | 49994 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 8 | Permit Number 46738 | 6011568.01566 | 2104131.09801 | 37.7581949848158 | -122.403015130859 | (37.7581949848158, -122.403015130859) | 10 | 3 | 8 | 28856 | 29 | |
147417 | 229791 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007593.88535 | 2107340.09456 | 37.7667834204575 | -122.416986798497 | (37.7667834204575, -122.416986798497) | 8 | 4 | 7 | 28853 | 19 | |||
146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
146523 | 226382 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009331.97291 | 2097098.94639 | 37.7387611354248 | -122.410251874634 | (37.7387611354248, -122.410251874634) | 10 | 7 | 7 | 28859 | 2 | |||
146505 | 68109 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.7453433283283 | -122.414106634567 | (37.7453433283283, -122.414106634567) | 2 | 7 | 7 | 28859 | 2 | ||
146330 | 228550 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1376 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009526.3637 | 2101188.14814 | 37.7500000817346 | -122.40986833805 | (37.7500000817346, -122.40986833805) | 2 | 4 | 7 | 28859 | 19 | |||
146308 | 226381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.7404227444144 | -122.410529710297 | (37.7404227444144, -122.410529710297) | 10 | 7 | 7 | 28859 | 2 | |||
146261 | 34732 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1417 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38383 | 6006486.84635329 | 2101329.65317057 | 37.7502178094357 | -122.420389210833 | (37.7502178094357, -122.420389210833) | 2 | 4 | 7 | 28859 | 19 | |||
146209 | 74729 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 3174-3190 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1996 12:00:00 AM | 6008516.4229759 | 2101575.33994414 | 37.7510065716159 | -122.413388156863 | (37.7510065716159, -122.413388156863) | 2 | 4 | 7 | 28859 | 19 | ||||
146004 | 201527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 740 Earl St | 4 | : | Tree | Private 2 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.7300525126033 | -122.371951898056 | (37.7300525126033, -122.371951898056) | 10 | 3 | 8 | 58 | 1 | |||
145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | 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 | ||
145866 | 91415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 46 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2009 12:00:00 AM | 3x3 | Permit Number 52098 | 6003215 | 2107427 | 37.7667747483278 | -122.432138830712 | (37.7667747483278, -122.432138830712) | 15 | 5 | 5 | 28862 | 3 | ||
145243 | 226418 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008030.04777 | 2101411.71526 | 37.7505299748764 | -122.415058515332 | (37.7505299748764, -122.415058515332) | 2 | 4 | 7 | 28859 | 19 | |||
145234 | 33027 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
144753 | 229809 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1801 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009528.66718 | 2106237.67868 | 37.7638650844166 | -122.410216840643 | (37.7638650844166, -122.410216840643) | 8 | 4 | 8 | 28859 | 19 | |||
144457 | 37759 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.7512141902983 | -122.40794259966 | (37.7512141902983, -122.40794259966) | 2 | 4 | 7 | 28859 | 19 | ||
143926 | 229768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011450.10406 | 2102428.33109 | 37.7535129775571 | -122.403303138733 | (37.7535129775571, -122.403303138733) | 10 | 4 | 8 | 28859 | 19 | |||
143831 | 36060 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 3 | 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 | |||
143485 | 190686 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014799.41703 | 2106205.91343 | 37.7640718970256 | -122.391984541257 | (37.7640718970256, -122.391984541257) | 14 | 3 | 8 | 28856 | 29 | |||
143048 | 36511 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50549 | 6007227.68347498 | 2097723.04326722 | 37.7403565876102 | -122.417571756215 | (37.7403565876102, -122.417571756215) | 2 | 7 | 7 | 28859 | 2 | ||
142907 | 34337 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 14 | 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 | ||||
142727 | 121739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
142531 | 43929 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1097x York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43519 | 6010038 | 2102851 | 37.7545945643559 | -122.408216329842 | (37.7545945643559, -122.408216329842) | 2 | 4 | 7 | 28859 | 19 | ||
142068 | 138814 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 456 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005154.2758 | 2111127.9762 | 37.777046493419 | -122.425694638339 | (37.777046493419, -122.425694638339) | 7 | 9 | 11 | 28852 | 10 | |||
141895 | 67581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.36958 | 37.7622066365616 | -122.39736679307 | (37.7622066365616, -122.39736679307) | 10 | 3 | 8 | 28856 | 29 | |
141843 | 226456 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008043.14081 | 2104467.44618 | 37.7589210533947 | -122.41522952324 | (37.7589210533947, -122.41522952324) | 2 | 4 | 7 | 28859 | 19 | |||
141722 | 26501 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008910.69527 | 2102429.93481 | 37.7533752266066 | -122.412085108448 | (37.7533752266066, -122.412085108448) | 2 | 4 | 7 | 28859 | 19 | |||
141115 | 34778 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
140964 | 39588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.11928 | 37.7562633193119 | -122.401863767506 | (37.7562633193119, -122.401863767506) | 10 | 3 | 8 | 28856 | 29 | |
140846 | 229886 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646 | (37.7458924813579, -122.41507891646) | 2 | 7 | 7 | 28859 | 2 | |||
140682 | 66211 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 543 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 6 | 3x3 | Permit Number 53588 | 6011817.82357 | 2105837.41873 | 37.7628941088863 | -122.402271150494 | (37.7628941088863, -122.402271150494) | 8 | 3 | 8 | 28856 | 29 |
140532 | 226793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.14773 | 2103676.31571 | 37.7564148838461 | -122.435612414605 | (37.7564148838461, -122.435612414605) | 2 | 4 | 5 | 28862 | 3 | |||
140480 | 226425 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005988.79838 | 2101974.74893 | 37.7519610156893 | -122.422157319311 | (37.7519610156893, -122.422157319311) | 2 | 4 | 5 | 28859 | 19 | |||
140189 | 226761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005532.06027 | 2099607.16908 | 37.7454344125679 | -122.423568476998 | (37.7454344125679, -122.423568476998) | 2 | 7 | 5 | 28859 | 22 | |||
140045 | 226369 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | 2 | 4 | 5 | 28862 | 22 | |||
139718 | 34979 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 4 | 4.5x5.5 | Permit Number 38560 | 6005404.47969691 | 2102506.81993306 | 37.7533889843192 | -122.424215816798 | (37.7533889843192, -122.424215816798) | 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) );