trees
1,985 rows where qSpecies_id = 83 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194376 | 171271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004457.49043 | 2092972.68503 | 37.7271569051579 | -122.426811773162 | (37.7271569051579, -122.426811773162) | 9 | 7 | 6 | 28861 | 5 | ||
| 194093 | 24686 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.7797664796243 | -122.490106359296 | (37.7797664796243, -122.490106359296) | 11 | 6 | 2 | 55 | 26 | ||
| 193954 | 15605 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3349 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 6006192.9166 | 2098824.6926 | 37.743323189063 | -122.42122778434 | (37.743323189063, -122.42122778434) | 2 | 7 | 7 | 28859 | 2 | ||
| 193931 | 60620 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 221 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20245 | 6004788.53237408 | 2097060.23831103 | 37.7383991243874 | -122.425958210014 | (37.7383991243874, -122.425958210014) | 2 | 7 | 5 | 63 | 7 | ||
| 193929 | 93824 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 193928 | 139274 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 725 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004227.9769 | 2111481.8263 | 37.7779656924567 | -122.428924228419 | (37.7779656924567, -122.428924228419) | 7 | 9 | 11 | 28852 | 10 | |||
| 193699 | 95794 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317 | 2101466 | 37.7508072797373 | -122.407153846535 | (37.7508072797373, -122.407153846535) | 2 | 4 | 7 | 28859 | 19 | |
| 193694 | 246064 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 601 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997522.9034 | 2108415.3867 | 37.7691642400439 | -122.451898056524 | (37.7691642400439, -122.451898056524) | 15 | 5 | 11 | 29492 | 9 | |||
| 193678 | 239272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007373.32106 | 2107298.89674 | 37.7666578912871 | -122.417746775107 | (37.7666578912871, -122.417746775107) | 8 | 4 | 7 | 28853 | 19 | |||
| 193611 | 60120 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 231 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19647 | 6004727.57850512 | 2096979.14667455 | 37.7381730200844 | -122.426163187426 | (37.7381730200844, -122.426163187426) | 2 | 7 | 5 | 63 | 7 | ||
| 193501 | 179308 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6003895.65676 | 2092365.82614 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | 9 | 7 | 6 | 28861 | 5 | |||
| 193456 | 248000 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 402 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009971.14082 | 2098682.22782 | 37.7431442907726 | -122.408153555751 | (37.7431442907726, -122.408153555751) | 10 | 7 | 7 | 28859 | 2 | |||
| 193279 | 179285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010162.36149 | 2089750.07728 | 37.7186291998585 | -122.406862968371 | (37.7186291998585, -122.406862968371) | 10 | 7 | 8 | 309 | 39 | |||
| 193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 193114 | 193324 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015583.67362 | 2102658.40109 | 37.7543746962452 | -122.389024300455 | (37.7543746962452, -122.389024300455) | 10 | 3 | 8 | 28856 | 29 | |||
| 192825 | 213924 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1973 12:00:00 AM | 4 | Width 3ft | Permit Number 11824 | 5996368.87449 | 2106798.14834 | 37.7646575544173 | -122.455772834368 | (37.7646575544173, -122.455772834368) | 15 | 5 | 11 | 29492 | 12 | |
| 192729 | 136204 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3898 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5996215.93738 | 2115261.69586 | 37.7878874538988 | -122.456914002974 | (37.7878874538988, -122.456914002974) | 11 | 6 | 1 | 54 | 31 | |||
| 192585 | 93830 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 192496 | 85645 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1313 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016677.8494 | 2093524.29 | 37.7293548752151 | -122.384604114815 | (37.7293548752151, -122.384604114815) | 10 | 3 | 8 | 58 | 1 | ||
| 192403 | 85487 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.7270015877346 | -122.406257791158 | (37.7270015877346, -122.406257791158) | 10 | 3 | 7 | 309 | 28 | ||
| 192376 | 16544 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016074.64629 | 2097992.47705 | 37.7415902397879 | -122.387000971524 | (37.7415902397879, -122.387000971524) | 10 | 3 | 8 | 58 | 1 | |||
| 192309 | 85631 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015497.489334 | 2094466.503619 | 37.7318766579731 | -122.388750513143 | (37.7318766579731, -122.388750513143) | 10 | 3 | 8 | 58 | 1 | ||
| 192273 | 55270 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 809 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32396 | 5992382.44974981 | 2102648.13821757 | 37.7530331280839 | -122.469258615605 | (37.7530331280839, -122.469258615605) | 1 | 8 | 4 | 56 | 12 | ||
| 192208 | 240180 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008254.09787 | 2096890.00313 | 37.7381269442938 | -122.413963894722 | (37.7381269442938, -122.413963894722) | 2 | 7 | 7 | 28859 | 2 | |||
| 192122 | 179301 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003618.31142 | 2092719.86754 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | 9 | 7 | 6 | 28861 | 5 | |||
| 191969 | 88491 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.7324604500235 | -122.389636207884 | (37.7324604500235, -122.389636207884) | 10 | 3 | 8 | 58 | 1 | ||
| 191940 | 48987 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 466 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2002 12:00:00 AM | Permit Number 46174 | 6003488.63823047 | 2100126.88002521 | 37.7467458648752 | -122.430671379901 | (37.7467458648752, -122.430671379901) | 2 | 7 | 5 | 63 | 22 | ||
| 191815 | 60625 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 315 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20250 | 6004228.6895082 | 2096570.52426476 | 37.7370228251858 | -122.427858989442 | (37.7370228251858, -122.427858989442) | 2 | 7 | 5 | 63 | 7 | ||
| 191712 | 240152 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1520 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998350.81999 | 2105225.15153 | 37.7604520448521 | -122.448804531031 | (37.7604520448521, -122.448804531031) | 15 | 5 | 11 | 29492 | 12 | |||
| 191565 | 244318 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 331 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/02/2017 04:08:00 PM | 3 | Width 0ft | 6005494.8083 | 2110541.2729 | 37.7754547855001 | -122.424474886956 | (37.7754547855001, -122.424474886956) | 7 | 9 | 11 | 28852 | 10 | ||
| 191489 | 100411 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 201x Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435 | 2110776 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | 7 | 9 | 11 | 28852 | 10 | |||
| 191475 | 31193 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 218 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34886 | 6011113.20919467 | 2107342.89093281 | 37.7669884386727 | -122.40481417533 | (37.7669884386727, -122.40481417533) | 8 | 2 | 8 | 28853 | 19 | |||
| 191471 | 111909 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 191414 | 247591 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 800 Tompkins Ave | 12 | Front Yard : Yard | Tree | Private 2 | 10 | 6008974.65943 | 2096434.52097 | 37.7369167320297 | -122.411440373668 | (37.7369167320297, -122.411440373668) | 10 | 7 | 7 | 28859 | 2 | ||||
| 191253 | 239325 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 26 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009350.01559 | 2099840.2126 | 37.7462890644043 | -122.410382996672 | (37.7462890644043, -122.410382996672) | 2 | 7 | 7 | 28859 | 2 | |||
| 191089 | 24470 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.422102071167 | (37.7729259368552, -122.422102071167) | 7 | 2 | 9 | 28853 | 19 | ||
| 191049 | 240203 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 50 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002560.6439 | 2096455.85562 | 37.736613467133 | -122.433617972817 | (37.736613467133, -122.433617972817) | 2 | 7 | 5 | 63 | 7 | |||
| 190752 | 159145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 291 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:23:00 AM | 3 | Width 0ft | 5999009.28945 | 2088027.75173 | 37.7132697053972 | -122.445290696322 | (37.7132697053972, -122.445290696322) | 9 | 7 | 6 | 28861 | 25 | ||
| 190612 | 213993 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | 9 | 7 | 5 | 63 | 40 | |||
| 190545 | 69359 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 6 | Permit Number 33453 | 6004667.12401 | 2120354.39385 | 37.8023523736266 | -122.428037496051 | (37.8023523736266, -122.428037496051) | 13 | 9 | 1 | 57 | 17 | |
| 190435 | 240164 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | 15 | 5 | 11 | 29492 | 9 | |||
| 190332 | 49548 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2434@ TARAVAL 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2003 12:00:00 AM | 1 | Permit Number 46439 | 5989857.9655 | 2098790.1552 | 37.742293916006 | -122.477706691652 | (37.742293916006, -122.477706691652) | 1 | 8 | 3 | 29491 | 35 | ||
| 190123 | 121096 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1691 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001097 | 2111345 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | 15 | 5 | 11 | 29492 | 41 | |||
| 190087 | 69353 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.01209 | 37.8028503021536 | -122.427255965393 | (37.8028503021536, -122.427255965393) | 13 | 9 | 1 | 57 | 17 | |
| 189933 | 8911 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4455X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5993163.73313 | 2112722.6581 | 37.7807402102496 | -122.467289289157 | (37.7807402102496, -122.467289289157) | 11 | 6 | 2 | 54 | 11 | |||
| 189620 | 197147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.382881628681 | (37.7332841805136, -122.382881628681) | 10 | 3 | 8 | 58 | 1 | |||
| 189553 | 175420 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | 9 | 7 | 6 | 28861 | 5 | |||
| 189548 | 110940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1944X FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6003020 | 2115096 | 37.7878208557656 | -122.433361372735 | (37.7878208557656, -122.433361372735) | 13 | 9 | 11 | 29490 | 27 | |||
| 189409 | 16496 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 305X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016807.79285 | 2098273.54956 | 37.7424025765764 | -122.384485547297 | (37.7424025765764, -122.384485547297) | 10 | 3 | 8 | 58 | 1 | ||
| 189323 | 239303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 827 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009943.30832 | 2104181.78404 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | 2 | 4 | 7 | 28859 | 19 | |||
| 189290 | 213988 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992833.78766 | 2098132.51162 | 37.7406604415293 | -122.467369487819 | (37.7406604415293, -122.467369487819) | 1 | 8 | 4 | 59 | 40 | |||
| 189284 | 90389 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 68 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.7734415707499 | -122.419216927652 | (37.7734415707499, -122.419216927652) | 8 | 2 | 9 | 28853 | 19 | ||
| 189124 | 213971 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.07265 | 2091112.61421 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | 9 | 8 | 6 | 28861 | 24 | |||
| 189045 | 115209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 777466 | 5997030.13095 | 2115907.11493 | 37.7897063219407 | -122.454143692681 | (37.7897063219407, -122.454143692681) | 11 | 6 | 1 | 54 | 31 | ||
| 188895 | 63706 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 634 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | 5x4 | Permit Number 24367 | 6007869.12350013 | 2104228.71879898 | 37.7582557814133 | -122.415814454004 | (37.7582557814133, -122.415814454004) | 2 | 4 | 7 | 28859 | 19 | |
| 188714 | 9553 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
| 188597 | 50021 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 137@ FELTON Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 8 | Permit Number 46755 | 6010268.64963 | 2093971.72397 | 37.7302269091391 | -122.406792936365 | (37.7302269091391, -122.406792936365) | 10 | 3 | 7 | 309 | 28 | |
| 188580 | 136218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002000.86832 | 2118219.41961 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | 13 | 9 | 1 | 57 | 17 | |||
| 188470 | 64257 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 187 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25058 | 6004735.81320328 | 2098680.88215868 | 37.7428460643577 | -122.426255838051 | (37.7428460643577, -122.426255838051) | 2 | 7 | 5 | 63 | 22 | ||
| 188228 | 21208 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2392X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
| 187966 | 7328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2042 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002935.65629 | 2115353.59376 | 37.7885233572924 | -122.433671603208 | (37.7885233572924, -122.433671603208) | 13 | 9 | 1 | 29490 | 27 | |||
| 187914 | 96049 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 | |
| 187897 | 96107 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
| 187407 | 52637 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2@ PACIFIC Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2006 12:00:00 AM | 8 | Permit Number 48719 | 5997984.07214 | 2116339.17658 | 37.7909473027338 | -122.450874333286 | (37.7909473027338, -122.450874333286) | 13 | 6 | 1 | 54 | 31 | ||
| 187007 | 240132 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.426821519118 | (37.7562000502026, -122.426821519118) | 2 | 4 | 5 | 28862 | 22 | |||
| 186997 | 20137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412023 | 37.7774730322357 | -122.433127623561 | (37.7774730322357, -122.433127623561) | 15 | 9 | 11 | 29492 | 10 | |
| 186933 | 61372 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.45241 | 2119937.78509 | 37.800886538036 | -122.447599568972 | (37.800886538036, -122.447599568972) | 13 | 9 | 1 | 57 | 17 | |
| 186835 | 8082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 755X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1992 12:00:00 AM | 6 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | 7 | 9 | 11 | 28852 | 10 | ||
| 186691 | 57983 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 239 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25821 | 6004979.2268936 | 2099866.02036455 | 37.7461139385723 | -122.425498506263 | (37.7461139385723, -122.425498506263) | 2 | 7 | 5 | 63 | 22 | ||
| 186686 | 63885 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3541 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24592 | 6004749.93985328 | 2103654.2602179 | 37.7565026069038 | -122.426561053788 | (37.7565026069038, -122.426561053788) | 2 | 4 | 5 | 28862 | 22 | ||
| 186592 | 240172 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008195.53017 | 2096250.88007 | 37.7363687625138 | -122.414121189761 | (37.7363687625138, -122.414121189761) | 2 | 7 | 7 | 28859 | 2 | |||
| 186339 | 85654 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1699X Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.773563 | 37.7331505648623 | -122.391235394882 | (37.7331505648623, -122.391235394882) | 10 | 3 | 8 | 58 | 1 | ||
| 185948 | 239289 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 614 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009797.57319 | 2105357.14674 | 37.7614624133911 | -122.409224632138 | (37.7614624133911, -122.409224632138) | 2 | 4 | 8 | 28859 | 19 | |||
| 185801 | 197135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Newhall St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015262.92854 | 2096819.74111 | 37.7383251674823 | -122.389725749154 | (37.7383251674823, -122.389725749154) | 10 | 3 | 8 | 58 | 1 | |||
| 185707 | 30630 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008012.82240629 | 2108413.03711614 | 37.7697530267823 | -122.415613735449 | (37.7697530267823, -122.415613735449) | 8 | 4 | 9 | 28853 | 19 | |
| 185675 | 179317 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 213 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009388.38978 | 2094971.87362 | 37.7329238140651 | -122.40990669865 | (37.7329238140651, -122.40990669865) | 10 | 3 | 7 | 309 | 28 | |||
| 185476 | 239357 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1436 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003898.77932 | 2099900.14022 | 37.7461465173604 | -122.429236987519 | (37.7461465173604, -122.429236987519) | 2 | 7 | 5 | 63 | 22 | |||
| 185252 | 1848 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011043.02806 | 2086938.15421 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | 10 | 3 | 8 | 309 | 1 | |||
| 185242 | 41522 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 3 | Permit Number 42063 | 6014186.00908 | 2106172.78785 | 37.7639468669737 | -122.39410383682 | (37.7639468669737, -122.39410383682) | 14 | 3 | 8 | 28856 | 29 | ||
| 185157 | 138547 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1640 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001637.8568 | 2114160.6327 | 37.7851740682459 | -122.438076291996 | (37.7851740682459, -122.438076291996) | 13 | 6 | 11 | 29490 | 13 | |||
| 185001 | 240158 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 569 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1969 12:00:00 AM | 6 | Width 3ft | Permit Number 6318 | 5998608.31571 | 2105895.72511 | 37.7623079937314 | -122.447962256561 | (37.7623079937314, -122.447962256561) | 15 | 5 | 11 | 29492 | 9 | |
| 184771 | 14782 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1037 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 4X4 | 6004198.5372 | 2111824.0669 | 37.7789037342236 | -122.429050478372 | (37.7789037342236, -122.429050478372) | 7 | 9 | 11 | 29490 | 41 | |||
| 184637 | 92268 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767 | 2098334 | 37.7412098217915 | -122.467615061471 | (37.7412098217915, -122.467615061471) | 1 | 8 | 4 | 59 | 40 | ||
| 184542 | 24098 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 105X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
| 184540 | 4363 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 16X Burnside Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2005 12:00:00 AM | 3 | 3x3 | 6001247.5637 | 2095900.96034 | 37.7350152618906 | -122.438118108566 | (37.7350152618906, -122.438118108566) | 2 | 7 | 5 | 63 | 7 | ||
| 184497 | 199941 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017637.764 | 2092806.0386 | 37.7274357354826 | -122.381235645904 | (37.7274357354826, -122.381235645904) | 10 | 3 | 8 | 58 | 1 | |||
| 184472 | 197091 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6014475.63706 | 2102134.76481 | 37.7528754202862 | -122.392819573486 | (37.7528754202862, -122.392819573486) | 10 | 3 | 8 | 28856 | 29 | |||
| 184416 | 9550 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | |||
| 184251 | 113166 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | 11 | 6 | 1 | 54 | 31 | |||
| 183996 | 111907 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1699x WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006657 | 2116952 | 37.7931226344993 | -122.420909832708 | (37.7931226344993, -122.420909832708) | 13 | 9 | 10 | 28858 | 32 | ||||
| 183966 | 197150 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 102 Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016678.04362 | 2095528.85162 | 37.7348590139212 | -122.38474302839 | (37.7348590139212, -122.38474302839) | 10 | 3 | 8 | 58 | 1 | |||
| 183951 | 102763 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 50X Hill Point Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3x3 | Permit Number 769605 | 5996378.1 | 2106680.6 | 37.7643353262738 | -122.455732428347 | (37.7643353262738, -122.455732428347) | 15 | 5 | 11 | 29492 | 12 | |
| 183795 | 94653 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 486 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53792 | 6003723 | 2095910 | 37.7351805553154 | -122.429560291545 | (37.7351805553154, -122.429560291545) | 2 | 7 | 5 | 63 | 7 | |
| 183792 | 15609 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006037.9197 | 2098666.6602 | 37.7428805283754 | -122.421752501895 | (37.7428805283754, -122.421752501895) | 2 | 7 | 7 | 28859 | 2 | ||
| 183617 | 63870 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 419 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1993 12:00:00 AM | Permit Number 32273 | 6003609.32170221 | 2103297.27758201 | 37.7554578688081 | -122.430480244546 | (37.7554578688081, -122.430480244546) | 2 | 4 | 5 | 28862 | 22 | ||
| 183528 | 91610 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | 2 | 4 | 7 | 28859 | 19 | |||
| 183359 | 93823 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 183283 | 7311 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1932 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | 6002980.7419 | 2115020.0739 | 37.78761015473 | -122.433491770285 | (37.78761015473, -122.433491770285) | 13 | 9 | 11 | 29490 | 27 | |||
| 182977 | 136191 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002535.25273 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | 13 | 9 | 1 | 57 | 17 | |||
| 182772 | 247566 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 318 Alemany Blvd | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6008741.21767 | 2095435.43504 | 37.7341603621059 | -122.412176898651 | (37.7341603621059, -122.412176898651) | 10 | 7 | 7 | 28859 | 2 |
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) );