trees
2,365 rows where qSpecies_id = 31 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8784 | 46303 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 9121 | 46285 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 10022 | 46302 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 14244 | 46291 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 146546 | 136974 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001080.18174 | 2119739.07113 | 37.8004592737451 | -122.440405888327 | (37.8004592737451, -122.440405888327) | 13 | 9 | 1 | 57 | 17 | |||
| 40679 | 123696 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995493.19231 | 2113537.8911 | 37.7831128208781 | -122.459289671188 | (37.7831128208781, -122.459289671188) | 11 | 6 | 2 | 54 | 11 | |||
| 44191 | 123695 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995508.22475 | 2113538.45627 | 37.7831152369297 | -122.459237706338 | (37.7831152369297, -122.459237706338) | 11 | 6 | 2 | 54 | 11 | |||
| 134543 | 242778 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 McCoppin St | 1 | : | Tree | Private 2 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | 8 | 2 | 9 | 28853 | 19 | |||
| 121544 | 215482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994118.54253 | 2097814.90929 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | 1 | 8 | 4 | 59 | 40 | |||
| 175856 | 215481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.7399367588722 | -122.462836916405 | (37.7399367588722, -122.462836916405) | 1 | 8 | 4 | 59 | 40 | |||
| 80227 | 141757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003947.6557 | 2113327.5266 | 37.7830176559931 | -122.430025655042 | (37.7830176559931, -122.430025655042) | 7 | 9 | 11 | 29490 | 41 | |||
| 82231 | 141754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003957.9028 | 2113249.5012 | 37.7828039980646 | -122.429984636672 | (37.7828039980646, -122.429984636672) | 7 | 9 | 11 | 29490 | 41 | |||
| 95098 | 141755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003953.8461 | 2113272.9385 | 37.7828681212931 | -122.430000343557 | (37.7828681212931, -122.430000343557) | 7 | 9 | 11 | 29490 | 41 | |||
| 105079 | 141762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003923.1755 | 2113496.0743 | 37.7834790593899 | -122.430122374293 | (37.7834790593899, -122.430122374293) | 7 | 9 | 11 | 29490 | 41 | |||
| 115537 | 141758 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003941.7467 | 2113359.8855 | 37.7831061707931 | -122.430048406845 | (37.7831061707931, -122.430048406845) | 7 | 9 | 11 | 29490 | 41 | |||
| 158406 | 141756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003949.9068 | 2113305.5788 | 37.7829575203066 | -122.430016301018 | (37.7829575203066, -122.430016301018) | 7 | 9 | 11 | 29490 | 41 | |||
| 162776 | 141760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003934.4308 | 2113424.6033 | 37.7832834553568 | -122.430078335144 | (37.7832834553568, -122.430078335144) | 7 | 9 | 11 | 29490 | 41 | |||
| 177497 | 141759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003937.2446 | 2113390.8375 | 37.7831909022721 | -122.430066191 | (37.7831909022721, -122.430066191) | 7 | 9 | 11 | 29490 | 41 | |||
| 184946 | 141761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003925.4266 | 2113468.4989 | 37.7834034717338 | -122.430112618538 | (37.7834034717338, -122.430112618538) | 7 | 9 | 11 | 29490 | 41 | |||
| 146011 | 242590 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000566.18522 | 2102752.01252 | 37.7537878463488 | -122.440965200093 | (37.7537878463488, -122.440965200093) | 2 | 4 | 5 | 28862 | 22 | |||
| 97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 9 | 7 | 6 | 28861 | 5 | |||
| 2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
| 98495 | 198597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013173.33118 | 2107113.60808 | 37.7664738135381 | -122.397672404268 | (37.7664738135381, -122.397672404268) | 14 | 3 | 8 | 28856 | 20 | |||
| 110681 | 198594 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013331.88607 | 2107121.53391 | 37.7665044039878 | -122.39712454356 | (37.7665044039878, -122.39712454356) | 14 | 3 | 8 | 28856 | 20 | |||
| 116784 | 198596 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013207.26395 | 2107117.31767 | 37.7664858887413 | -122.397555296343 | (37.7664858887413, -122.397555296343) | 14 | 3 | 8 | 28856 | 20 | |||
| 143260 | 198595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013296.53525 | 2107120.49149 | 37.7664995737224 | -122.397246743447 | (37.7664995737224, -122.397246743447) | 14 | 3 | 8 | 28856 | 20 | |||
| 184345 | 198593 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013352.21579 | 2107122.2943 | 37.7665076235661 | -122.397054279536 | (37.7665076235661, -122.397054279536) | 14 | 3 | 8 | 28856 | 20 | |||
| 137339 | 17609 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910287 | (37.7191632136975, -122.42781910287) | 9 | 7 | 6 | 28861 | 5 | |||
| 144805 | 17610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004083.79011 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | 9 | 7 | 6 | 28861 | 5 | |||
| 154623 | 17608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | 9 | 7 | 6 | 28861 | 5 | ||
| 64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
| 43528 | 17611 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 169347 | 17613 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 179430 | 17612 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 121132 | 19301 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995247.10654 | 2111496.409 | 37.7774933045144 | -122.459993084378 | (37.7774933045144, -122.459993084378) | 11 | 6 | 2 | 54 | 11 | |||
| 155936 | 102761 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
| 6138 | 244422 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.7731308974862 | -122.423735193743 | (37.7731308974862, -122.423735193743) | 7 | 9 | 11 | 28852 | 10 | |||
| 31182 | 244424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.423754560713 | (37.7732378565997, -122.423754560713) | 7 | 9 | 11 | 28852 | 10 | |||
| 81285 | 244426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.7733541831734 | -122.423776541571 | (37.7733541831734, -122.423776541571) | 7 | 9 | 11 | 28852 | 10 | |||
| 84842 | 244328 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | 7 | 9 | 11 | 28852 | 10 | |||
| 88042 | 244423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | 7 | 9 | 11 | 28852 | 10 | |||
| 89789 | 244330 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.423838604142 | (37.7736448835433, -122.423838604142) | 7 | 9 | 11 | 28852 | 10 | |||
| 100227 | 244327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.423804755705 | (37.773436531636, -122.423804755705) | 7 | 9 | 11 | 28852 | 10 | |||
| 119447 | 244425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005682.2494 | 2109755.2828 | 37.7733072300695 | -122.423770583723 | (37.7733072300695, -122.423770583723) | 7 | 9 | 11 | 28852 | 10 | |||
| 124514 | 244421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.7730821016693 | -122.423726816669 | (37.7730821016693, -122.423726816669) | 7 | 9 | 11 | 28852 | 10 | |||
| 129666 | 244331 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005661.6953 | 2109906.0133 | 37.7737199393103 | -122.423852403284 | (37.7737199393103, -122.423852403284) | 7 | 9 | 11 | 28852 | 10 | |||
| 135699 | 244329 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005667.8615 | 2109858.0536 | 37.773588601657 | -122.423827662517 | (37.773588601657, -122.423827662517) | 7 | 9 | 11 | 28852 | 10 | |||
| 165131 | 16605 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 101 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2014 12:00:00 AM | 18 | 3X3 | Permit Number 773154 | 6002878.7558281 | 2107677.2386142 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | 15 | 5 | 5 | 28862 | 3 | |
| 43659 | 17498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.434870362385 | (37.72266164479, -122.434870362385) | 9 | 7 | 6 | 28861 | 5 | |||
| 90891 | 17497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.434919765734 | (37.7226823390961, -122.434919765734) | 9 | 7 | 6 | 28861 | 5 | |||
| 126316 | 17496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.20621 | 37.7227329421421 | -122.435027663714 | (37.7227329421421, -122.435027663714) | 9 | 7 | 6 | 28861 | 5 | ||
| 18136 | 112514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356399 | (37.7827619817135, -122.47018356399) | 11 | 6 | 2 | 54 | 11 | |||
| 175502 | 17615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004156.70512 | 2090037.90942 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | 9 | 7 | 6 | 28861 | 5 | |||
| 99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
| 11525 | 119754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 13324 | 119752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 14547 | 119749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 29976 | 244375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005617.5038 | 2109823.1115 | 37.7734898161448 | -122.423999372272 | (37.7734898161448, -122.423999372272) | 7 | 9 | 11 | 28852 | 10 | |||
| 33483 | 119753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
| 55145 | 119750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 74986 | 244345 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005607.2268 | 2109894.3659 | 37.7736848832921 | -122.424039990106 | (37.7736848832921, -122.424039990106) | 7 | 9 | 11 | 28852 | 10 | |||
| 86911 | 244468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | 7 | 9 | 11 | 28852 | 10 | |||
| 87894 | 244467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | 7 | 9 | 11 | 28852 | 10 | |||
| 95773 | 244344 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.7737487675431 | -122.424046387097 | (37.7737487675431, -122.424046387097) | 7 | 9 | 11 | 28852 | 10 | |||
| 112920 | 244466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | 7 | 9 | 11 | 28852 | 10 | |||
| 142693 | 244455 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | 7 | 9 | 11 | 28852 | 10 | |||
| 145347 | 244456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.7733190115017 | -122.423971237778 | (37.7733190115017, -122.423971237778) | 7 | 9 | 11 | 28852 | 10 | |||
| 149108 | 119747 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 154989 | 244465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | 7 | 9 | 11 | 28852 | 10 | |||
| 166196 | 119736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 181645 | 244373 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | 7 | 9 | 11 | 28852 | 10 | |||
| 190593 | 244374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.424012927889 | (37.7735554657504, -122.424012927889) | 7 | 9 | 11 | 28852 | 10 | |||
| 190598 | 119757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 191150 | 119756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 191279 | 119748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 44226 | 180517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004131.62894 | 2090104.37161 | 37.7192627191689 | -122.427733992853 | (37.7192627191689, -122.427733992853) | 9 | 7 | 6 | 28861 | 5 | |||
| 60428 | 180515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004177.13289 | 2090077.86698 | 37.7191925171931 | -122.427574815527 | (37.7191925171931, -122.427574815527) | 9 | 7 | 6 | 28861 | 5 | |||
| 174867 | 180516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004155.91588 | 2090090.60538 | 37.7192262939354 | -122.427649061763 | (37.7192262939354, -122.427649061763) | 9 | 7 | 6 | 28861 | 5 | |||
| 17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
| 61315 | 180513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004235.63883 | 2090036.93621 | 37.7190834393332 | -122.427369668478 | (37.7190834393332, -122.427369668478) | 9 | 7 | 6 | 28861 | 5 | |||
| 152862 | 180514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | 6004210.58168 | 2090053.82189 | 37.7191283865346 | -122.427457483699 | (37.7191283865346, -122.427457483699) | 9 | 7 | 6 | 28861 | 5 | |||
| 442 | 119718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 27032 | 119717 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 31673 | 119709 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 80215 | 119712 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 98216 | 119713 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 129678 | 119716 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 134418 | 119719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 192783 | 119714 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 148137 | 17616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004194.38835 | 2090014.04434 | 37.719018250172 | -122.427510625535 | (37.719018250172, -122.427510625535) | 9 | 7 | 6 | 28861 | 5 | |||
| 77852 | 7013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.7743154774203 | -122.435062751747 | (37.7743154774203, -122.435062751747) | 15 | 5 | 11 | 29492 | 10 | ||
| 185186 | 46875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) | 3 | 1 | 10 | 308 | 21 |
| 96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
| 15181 | 137040 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009716.37448 | 2116806.11676 | 37.7928940462749 | -122.410313864011 | (37.7928940462749, -122.410313864011) | 3 | 1 | 10 | 28857 | 21 | ||
| 147272 | 137039 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009772.70737 | 2116813.88249 | 37.7929185267084 | -122.410119497111 | (37.7929185267084, -122.410119497111) | 3 | 1 | 10 | 28857 | 21 |
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) );