trees
576 rows where Neighborhoods (old) = 19 and qSpecies_id = 50 sorted by Longitude
This data as json, CSV (advanced)
These facets timed out: Neighborhoods (old)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164341 | 229751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011465.75975 | 2102083.13702 | 37.7525660247145 | -122.40322471697 | (37.7525660247145, -122.40322471697) | 10 | 4 | 8 | 28859 | 19 | |||
| 88805 | 229752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011465.52618 | 2102102.51804 | 37.7526192277045 | -122.403226887931 | (37.7526192277045, -122.403226887931) | 10 | 4 | 8 | 28859 | 19 | |||
| 120093 | 229753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011465.79162 | 2102125.84808 | 37.7526833017063 | -122.403227610989 | (37.7526833017063, -122.403227610989) | 10 | 4 | 8 | 28859 | 19 | |||
| 120945 | 229754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.93054 | 2102145.24186 | 37.7527365046859 | -122.403231952908 | (37.7527365046859, -122.403231952908) | 10 | 4 | 8 | 28859 | 19 | |||
| 193911 | 229755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.403236063707 | (37.7528043666378, -122.403236063707) | 10 | 4 | 8 | 28859 | 19 | |||
| 29151 | 229756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.15557 | 2102190.87321 | 37.7528617550894 | -122.403237842573 | (37.7528617550894, -122.403237842573) | 10 | 4 | 8 | 28859 | 19 | |||
| 165791 | 229757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011461.99954 | 2102213.77594 | 37.752924520553 | -122.403246909533 | (37.752924520553, -122.403246909533) | 10 | 4 | 8 | 28859 | 19 | |||
| 102641 | 229758 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.403254066338 | (37.7529956524374, -122.403254066338) | 10 | 4 | 8 | 28859 | 19 | |||
| 187690 | 229759 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | 10 | 4 | 8 | 28859 | 19 | |||
| 54681 | 229760 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011458.91565 | 2102265.65077 | 37.7530667852271 | -122.403261223145 | (37.7530667852271, -122.403261223145) | 10 | 4 | 8 | 28859 | 19 | |||
| 18290 | 229761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.7531266009123 | -122.403271446634 | (37.7531266009123, -122.403271446634) | 10 | 4 | 8 | 28859 | 19 | |||
| 159856 | 229762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011454.29465 | 2102314.61303 | 37.7532009667707 | -122.403280647606 | (37.7532009667707, -122.403280647606) | 10 | 4 | 8 | 28859 | 19 | |||
| 38692 | 229763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011453.21392 | 2102329.36922 | 37.7532414236718 | -122.403285422977 | (37.7532414236718, -122.403285422977) | 10 | 4 | 8 | 28859 | 19 | |||
| 107367 | 229764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) | 10 | 4 | 8 | 28859 | 19 | |||
| 70055 | 229765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011453.42278 | 2102371.80516 | 37.7533579551144 | -122.403287685694 | (37.7533579551144, -122.403287685694) | 10 | 4 | 8 | 28859 | 19 | |||
| 41300 | 229766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011452.91917 | 2102390.65584 | 37.7534096868171 | -122.403290753279 | (37.7534096868171, -122.403290753279) | 10 | 4 | 8 | 28859 | 19 | |||
| 122297 | 229767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.403296886638 | (37.7534646524788, -122.403296886638) | 10 | 4 | 8 | 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 | |||
| 170096 | 229769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011449.91996 | 2102448.35306 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | 10 | 4 | 8 | 28859 | 19 | |||
| 36074 | 229770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011448.51225 | 2102466.33912 | 37.753617250357 | -122.403311317166 | (37.753617250357, -122.403311317166) | 10 | 4 | 8 | 28859 | 19 | |||
| 95325 | 229771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011447.67718 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | 10 | 4 | 8 | 28859 | 19 | |||
| 55327 | 229772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.86383 | 2102500.86077 | 37.7537119471592 | -122.403319446151 | (37.7537119471592, -122.403319446151) | 10 | 4 | 8 | 28859 | 19 | |||
| 15057 | 229773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.65854 | 2102520.54386 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | 10 | 4 | 8 | 28859 | 19 | |||
| 95655 | 229774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011445.35286 | 2102545.22023 | 37.7538336641006 | -122.403327791844 | (37.7538336641006, -122.403327791844) | 10 | 4 | 8 | 28859 | 19 | |||
| 1084 | 229775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.403338920978 | (37.7538928862632, -122.403338920978) | 10 | 4 | 8 | 28859 | 19 | |||
| 92812 | 229776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011441.50409 | 2102586.88485 | 37.7539478510307 | -122.40334403271 | (37.7539478510307, -122.40334403271) | 10 | 4 | 8 | 28859 | 19 | |||
| 127332 | 229777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011441.00674 | 2102606.02985 | 37.7540003912143 | -122.403347099413 | (37.7540003912143, -122.403347099413) | 10 | 4 | 8 | 28859 | 19 | |||
| 13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 31864 | 121730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 34391 | 121731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 90226 | 121729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 104984 | 121733 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 138812 | 121727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 2 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||||
| 189598 | 121735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 41670 | 229778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011440.8047 | 2102625.16918 | 37.7540529323224 | -122.403349144463 | (37.7540529323224, -122.403349144463) | 10 | 4 | 8 | 28859 | 19 | |||
| 168519 | 229779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011439.17328 | 2102646.69218 | 37.75411193863 | -122.403356300366 | (37.75411193863, -122.403356300366) | 10 | 4 | 8 | 28859 | 19 | |||
| 93661 | 229780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6011438.15067 | 2102669.08614 | 37.7541733704045 | -122.403361412121 | (37.7541733704045, -122.403361412121) | 10 | 4 | 8 | 28859 | 19 | |||
| 106642 | 229781 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011437.0323 | 2102686.77187 | 37.7542218690658 | -122.403366523848 | (37.7542218690658, -122.403366523848) | 10 | 4 | 8 | 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 | |||
| 2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 34062 | 121740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 74982 | 121755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 18 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 76026 | 121748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 89672 | 121756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 19 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 110905 | 121743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 116126 | 121744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 138150 | 121741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 159876 | 121752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 15 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 167786 | 121742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 174657 | 121750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 13 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 193199 | 121757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 20 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 161348 | 44333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2001 12:00:00 AM | Permit Number 43718 | 6011390.61929335 | 2101865.00809081 | 37.7519628937204 | -122.403469222223 | (37.7519628937204, -122.403469222223) | 10 | 4 | 8 | 28859 | 19 | ||
| 50723 | 229783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6011090.02369 | 2103815.82999 | 37.7573026253193 | -122.404646049572 | (37.7573026253193, -122.404646049572) | 10 | 4 | 8 | 28859 | 19 | |||
| 103487 | 80120 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1368 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53583 | 6010852.51966051 | 2101957.65368141 | 37.7521872076664 | -122.405336581456 | (37.7521872076664, -122.405336581456) | 10 | 4 | 8 | 28859 | 19 | ||
| 167994 | 229785 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010846.06079 | 2101951.02013 | 37.7521686322761 | -122.405358450228 | (37.7521686322761, -122.405358450228) | 10 | 4 | 8 | 28859 | 19 | |||
| 117745 | 229784 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1350 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010843.40414 | 2102039.00655 | 37.7524100750712 | -122.405373833155 | (37.7524100750712, -122.405373833155) | 10 | 4 | 8 | 28859 | 19 | |||
| 85653 | 34305 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38093 | 6010822.82923264 | 2102485.1673324 | 37.7536339837486 | -122.405476404222 | (37.7536339837486, -122.405476404222) | 10 | 4 | 8 | 28859 | 19 | ||
| 130053 | 229786 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010820.80874 | 2102463.77247 | 37.7535751252085 | -122.405481884883 | (37.7535751252085, -122.405481884883) | 10 | 4 | 8 | 28859 | 19 | |||
| 11549 | 70665 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010647.04803 | 2105639.57925 | 37.7622854639243 | -122.406306536234 | (37.7622854639243, -122.406306536234) | 8 | 4 | 8 | 28859 | 19 | |||
| 29685 | 190682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010644.58891 | 2105668.45784 | 37.7623646204591 | -122.406317076288 | (37.7623646204591, -122.406317076288) | 8 | 4 | 8 | 28859 | 19 | |||
| 14471 | 70661 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 460 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010614.613 | 2106160.28585 | 37.7637133921776 | -122.40645540999 | (37.7637133921776, -122.40645540999) | 8 | 4 | 8 | 28859 | 19 | |||
| 12120 | 70682 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010606.08274 | 2106339.87511 | 37.7642060264098 | -122.406497569303 | (37.7642060264098, -122.406497569303) | 8 | 4 | 8 | 28859 | 19 | |||
| 15198 | 70134 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.406595061225 | (37.7651517084965, -122.406595061225) | 8 | 4 | 8 | 28853 | 19 | |||
| 13796 | 46609 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1078 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44732 | 6010490.67134457 | 2102955.14321265 | 37.7549058552549 | -122.406658202843 | (37.7549058552549, -122.406658202843) | 10 | 4 | 7 | 28859 | 19 | |||
| 180841 | 190739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010536.50922 | 2107598.98356 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | 8 | 4 | 8 | 28853 | 19 | |||
| 21203 | 190740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010535.58814 | 2107583.98443 | 37.7676181235051 | -122.406829079197 | (37.7676181235051, -122.406829079197) | 8 | 4 | 8 | 28853 | 19 | |||
| 135288 | 190736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010534.2694 | 2107640.09784 | 37.7677721243224 | -122.406837595791 | (37.7677721243224, -122.406837595791) | 8 | 4 | 8 | 28853 | 19 | |||
| 98448 | 190738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010533.72626 | 2107613.44503 | 37.7676989114041 | -122.406837595798 | (37.7676989114041, -122.406837595798) | 8 | 4 | 8 | 28853 | 19 | |||
| 121316 | 190737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010533.36081 | 2107625.71159 | 37.7677325721273 | -122.406839724475 | (37.7677325721273, -122.406839724475) | 8 | 4 | 8 | 28853 | 19 | |||
| 160502 | 190735 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | 8 | 4 | 8 | 28853 | 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 | |||
| 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 | |||
| 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 | |||
| 48019 | 190731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010525.63223 | 2107742.12089 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | 8 | 4 | 8 | 28853 | 19 | |||
| 102667 | 190730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.7681196762964 | -122.406876984296 | (37.7681196762964, -122.406876984296) | 8 | 4 | 8 | 28853 | 19 | |||
| 175279 | 190729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010522.64899 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | 8 | 4 | 8 | 28853 | 19 | |||
| 63833 | 190728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.7682576862591 | -122.406890823964 | (37.7682576862591, -122.406890823964) | 8 | 4 | 8 | 28853 | 19 | |||
| 77015 | 190727 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010484.13409 | 2107848.45184 | 37.7683414113517 | -122.407025696183 | (37.7683414113517, -122.407025696183) | 8 | 4 | 8 | 28853 | 19 | |||
| 50377 | 18386 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | 10 | 4 | 7 | 28859 | 19 | ||
| 15185 | 223092 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2719 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782363 | 6010376.57029 | 2102801.69474 | 37.7544781353795 | -122.407041982913 | (37.7544781353795, -122.407041982913) | 10 | 4 | 7 | 28859 | 19 | |
| 127440 | 190721 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2200 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010462.79733 | 2107890.40635 | 37.7684554148125 | -122.407102456039 | (37.7684554148125, -122.407102456039) | 8 | 4 | 8 | 28853 | 19 | |||
| 46513 | 82600 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1380-1382 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52212 | 6010324.92053454 | 2101179.2577549 | 37.7500203919907 | -122.407106246848 | (37.7500203919907, -122.407106246848) | 2 | 4 | 7 | 28859 | 19 | |
| 53107 | 190726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010460.27046 | 2107847.89076 | 37.7683385353269 | -122.40710819908 | (37.7683385353269, -122.40710819908) | 8 | 4 | 8 | 28853 | 19 | |||
| 124658 | 228541 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1380 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 782155 | 6010322.60009 | 2101256.71389 | 37.7502329396187 | -122.407119730208 | (37.7502329396187, -122.407119730208) | 2 | 4 | 7 | 28859 | 19 | ||
| 117455 | 190725 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.407179113336 | (37.7683353022519, -122.407179113336) | 8 | 4 | 8 | 28853 | 19 | |||
| 127965 | 36578 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2833 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2002 12:00:00 AM | Permit Number 39440 | 6010288.37913672 | 2101036.1480817 | 37.7496253993391 | -122.407222522654 | (37.7496253993391, -122.407222522654) | 2 | 4 | 7 | 28859 | 19 | ||
| 9980 | 110373 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010419 | 2107687 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | 8 | 4 | 8 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );