trees
11,635 rows where qSpecies_id = 27 sorted by Zip Codes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1612 | 11759 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
2097 | 12450 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
2850 | 178600 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5989476.93903 | 2093627.59215 | 37.7280967254778 | -122.478646687712 | (37.7280967254778, -122.478646687712) | 1 | 8 | 4 | 64 | 14 | |||
16855 | 178604 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988124.07873 | 2089803.353 | 37.7175176953569 | -122.4830433365 | (37.7175176953569, -122.4830433365) | 1 | 8 | 4 | 64 | 14 | ||||
19876 | 291 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.29998 | 2093633.85413 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | 1 | 8 | 4 | 64 | 14 | ||
20049 | 11756 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 901X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
20795 | 254779 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 700 Brotherhood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
24222 | 12455 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
24816 | 215 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2940 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990603.87201 | 2095662.93623 | 37.7337506327847 | -122.474899387207 | (37.7337506327847, -122.474899387207) | 1 | 8 | 4 | 64 | 40 | ||
26401 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 345x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 5988176 | 2090635 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | 1 | 8 | 4 | 64 | 14 | ||||
29963 | 106965 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 63 BELLE AVE | Sidewalk: Property side : Yard | Tree | Private 2 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516 | (37.7085786821221, -122.47025464516) | 9 | 8 | 4 | 64 | 24 | ||||||
30330 | 12454 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
33521 | 205 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2918 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1994 12:00:00 AM | 10 | 2X3 | 5990601.80312 | 2095779.7077 | 37.7340711376763 | -122.474915060599 | (37.7340711376763, -122.474915060599) | 1 | 8 | 4 | 64 | 40 | ||
33620 | 289 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/1994 12:00:00 AM | 25 | 2 | 5990526.76624 | 2093758.79648 | 37.7285178779945 | -122.475027010894 | (37.7285178779945, -122.475027010894) | 1 | 8 | 4 | 64 | 14 | ||
40769 | 212741 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 142 Vernon St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5992469.93504 | 2088840.59445 | 37.7151261228375 | -122.467951845594 | (37.7151261228375, -122.467951845594) | 9 | 8 | 6 | 64 | 24 | |||
48713 | 221 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2955 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2008 12:00:00 AM | 6 | 2X3 | 5990527.06047 | 2095552.34344 | 37.7334425214563 | -122.475156873898 | (37.7334425214563, -122.475156873898) | 1 | 8 | 4 | 64 | 35 | ||
51598 | 203 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2912 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/02/1994 12:00:00 AM | 20 | 2X3 | 5990600.62302 | 2095815.84736 | 37.7341702996075 | -122.474921777626 | (37.7341702996075, -122.474921777626) | 1 | 8 | 4 | 64 | 40 | ||
53378 | 204 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2912 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1994 12:00:00 AM | 20 | 2X3 | 5990598.49618 | 2095837.81894 | 37.7342305047257 | -122.474930733974 | (37.7342305047257, -122.474930733974) | 1 | 8 | 4 | 64 | 40 | ||
55875 | 220 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2950 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 10 | 3X3 | 5990607.61646 | 2095564.18629 | 37.7334797075204 | -122.474879236111 | (37.7334797075204, -122.474879236111) | 1 | 8 | 4 | 64 | 40 | ||
56298 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 104x TAPIA DR | 1 | Front Yard : Cutout | Tree | Private 2 | 10 | 5988688 | 2090939 | 37.7206686952673 | -122.481177253578 | (37.7206686952673, -122.481177253578) | 1 | 8 | 4 | 64 | 14 | ||||
61574 | 261 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3100 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1994 12:00:00 AM | 12 | 2X3 | 5990658.74483 | 2094624.56369 | 37.7309027045274 | -122.474633919299 | (37.7309027045274, -122.474633919299) | 9 | 8 | 4 | 64 | 40 | ||
64990 | 274 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3210 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990651.75778 | 2094310.81175 | 37.7300408160247 | -122.474635184381 | (37.7300408160247, -122.474635184381) | 9 | 8 | 4 | 64 | 40 | ||
65168 | 253 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3070 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1994 12:00:00 AM | 10 | 2 | 5990634.6279 | 2094818.73559 | 37.7314344540416 | -122.474731461301 | (37.7314344540416, -122.474731461301) | 1 | 8 | 4 | 64 | 40 | ||
67725 | 178596 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 1 | : | Tree | Private 2 | 10 | Width 0ft | 5989485.56542 | 2093493.23297 | 37.7277283101093 | -122.478607044688 | (37.7277283101093, -122.478607044688) | 1 | 8 | 4 | 64 | 14 | |||
69807 | 12452 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
71325 | 245 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3030 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1994 12:00:00 AM | 12 | 2x3 | 5990627.42638 | 2094968.51009 | 37.7318452796259 | -122.4747672858 | (37.7318452796259, -122.4747672858) | 1 | 8 | 4 | 64 | 40 | ||
73583 | 94437 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3711@533 Gonzalez 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2010 12:00:00 AM | 32 | Permit Number 53664 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
77659 | 244 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3027 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 20 | 2 | 5990542.03599 | 2095003.84842 | 37.731937361205 | -122.475065073818 | (37.731937361205, -122.475065073818) | 1 | 8 | 4 | 64 | 35 | ||
79093 | 111089 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 10x HIGUERA AVE | 1 | Median : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777485 | 5988057 | 2090190 | 37.7185754269376 | -122.483303520979 | (37.7185754269376, -122.483303520979) | 1 | 8 | 4 | 64 | 14 | |
79201 | 115832 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 30x30 | Permit Number 777501 | 5990916 | 2088996 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | 1 | 8 | 4 | 64 | 14 | ||
84669 | 241 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3017 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990539.35496 | 2095091.61436 | 37.7321781888581 | -122.475080747187 | (37.7321781888581, -122.475080747187) | 1 | 8 | 4 | 64 | 35 | ||
86765 | 178603 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 700 Brotherhood Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | |||
87239 | 255702 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 654 Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 3ft | 5990422.48043 | 2088489.59506 | 37.7140439164585 | -122.475003050272 | (37.7140439164585, -122.475003050272) | 1 | 8 | 4 | 64 | 14 | ||||
89539 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990059 | 2093141 | 37.7267944442094 | -122.476598971146 | (37.7267944442094, -122.476598971146) | 1 | 8 | 4 | 64 | 14 | ||||
92272 | 231 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2000 12:00:00 AM | 16 | 2 | 5990528.92496 | 2095425.90129 | 37.7330954514847 | -122.475141200519 | (37.7330954514847, -122.475141200519) | 1 | 8 | 4 | 64 | 35 | ||
92891 | 178593 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2981 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5990533.36315 | 2095360.02657 | 37.7329148334525 | -122.475121049402 | (37.7329148334525, -122.475121049402) | 1 | 8 | 4 | 64 | 35 | |||
96916 | 292 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990518.98234 | 2093604.81674 | 37.7280946372571 | -122.475042684288 | (37.7280946372571, -122.475042684288) | 1 | 8 | 4 | 64 | 14 | ||
99550 | 87592 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3039 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5990542.94394 | 2094954.81496 | 37.7318027803631 | -122.475058356779 | (37.7318027803631, -122.475058356779) | 1 | 8 | 4 | 64 | 35 | ||||
99893 | 217 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2944 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990605.54964 | 2095619.69203 | 37.7336319924151 | -122.474890431755 | (37.7336319924151, -122.474890431755) | 1 | 8 | 4 | 64 | 40 | ||
100851 | 256441 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3001 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5984950 | 2095029 | 37.7316807417675 | -122.494399498116 | (37.7316807417675, -122.494399498116) | 1 | 8 | 4 | 64 | 35 | ||||
104872 | 242 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3017 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.15526 | 2095054.17081 | 37.7320754826964 | -122.475071790834 | (37.7320754826964, -122.475071790834) | 1 | 8 | 4 | 64 | 35 | ||
110677 | 208 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2924 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1994 12:00:00 AM | 7 | 3x3 | 5990600.55143 | 2095720.40284 | 37.7339082290639 | -122.4749150606 | (37.7339082290639, -122.4749150606) | 1 | 8 | 4 | 64 | 40 | ||
112706 | 211988 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 951 Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991299.37503 | 2091144.62881 | 37.7213847693696 | -122.472165612753 | (37.7213847693696, -122.472165612753) | 9 | 8 | 6 | 64 | 24 | |||
114440 | 178607 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.475437730361 | (37.7180635775375, -122.475437730361) | 1 | 8 | 4 | 64 | 14 | ||||
115112 | 120547 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 555 Buckingham Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989933 | 2094376 | 37.7301781328129 | -122.477124754151 | (37.7301781328129, -122.477124754151) | 1 | 8 | 4 | 64 | 14 | ||||
115284 | 178597 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 2 | : | Tree | Private 2 | 11 | Width 0ft | 5989487.40549 | 2093535.06487 | 37.727843276732 | -122.478603741492 | (37.727843276732, -122.478603741492) | 1 | 8 | 4 | 64 | 14 | |||
116417 | 104205 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
116986 | 248 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3050 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1994 12:00:00 AM | 20 | 2 | 5990629.27539 | 2094902.68874 | 37.7316646579979 | -122.474756091044 | (37.7316646579979, -122.474756091044) | 1 | 8 | 4 | 64 | 40 | ||
119671 | 285 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.55676 | 2093865.71504 | 37.7288118429831 | -122.47501133752 | (37.7288118429831, -122.47501133752) | 1 | 8 | 4 | 64 | 14 | ||
120064 | 12451 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
121747 | 178601 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 654 Brotherhood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990455.55423 | 2088469.00468 | 37.7139892970456 | -122.474887233782 | (37.7139892970456, -122.474887233782) | 1 | 8 | 4 | 64 | 14 | |||
121916 | 260 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3100 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4x4 | 5990641.60602 | 2094627.68915 | 37.7309102931528 | -122.474693398398 | (37.7309102931528, -122.474693398398) | 9 | 8 | 4 | 64 | 40 | |||
125580 | 111090 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 28x HIGUERA AVE | 1 | Median : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 3 | Permit Number 777485 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||
125665 | 256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3095 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990551.14028 | 2094790.83071 | 37.7313529961409 | -122.475018054557 | (37.7313529961409, -122.475018054557) | 1 | 8 | 4 | 64 | 35 | |||
127319 | 17174 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2999X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2 | 5990529.29755 | 2095287.65599 | 37.732715886568 | -122.475129823758 | (37.732715886568, -122.475129823758) | 1 | 8 | 4 | 64 | 35 | |||
127872 | 264 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3201X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1995 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
129900 | 254 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3080 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 12:00:00 AM | 13 | 2 | 5990635.11986 | 2094780.67442 | 37.7313299761991 | -122.474726983585 | (37.7313299761991, -122.474726983585) | 1 | 8 | 4 | 64 | 40 | ||
130471 | 254778 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 700 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
136235 | 216 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2944 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 20 | 3X3 | 5990608.35114 | 2095598.99571 | 37.7335753279252 | -122.474879236093 | (37.7335753279252, -122.474879236093) | 1 | 8 | 4 | 64 | 40 | ||
137594 | 206 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2919 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 6 | 2X3 | 5990516.43657 | 2095785.37905 | 37.7340817622493 | -122.475210610191 | (37.7340817622493, -122.475210610191) | 1 | 8 | 4 | 64 | 35 | ||
139475 | 211987 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 951 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991283.96245 | 2090948.88613 | 37.7208464163014 | -122.472204628055 | (37.7208464163014, -122.472204628055) | 9 | 8 | 6 | 64 | 24 | |||
140686 | 178599 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 5 | : | Tree | Private 2 | 9 | Width 0ft | 5989481.37307 | 2093611.32121 | 37.7280523070507 | -122.47863016984 | (37.7280523070507, -122.47863016984) | 1 | 8 | 4 | 64 | 14 | |||
141024 | 178605 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988508.84436 | 2089780.72483 | 37.7174779462404 | -122.481711737333 | (37.7174779462404, -122.481711737333) | 1 | 8 | 4 | 64 | 14 | ||||
142321 | 1261 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3833 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X6 | 5992776.62471 | 2087495.32693 | 37.7114500468546 | -122.466794068292 | (37.7114500468546, -122.466794068292) | 9 | 8 | 4 | 64 | 24 | |||
143404 | 104204 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
143554 | 111095 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 841x GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 3 | Permit Number 775593 | 5988358 | 2089771 | 37.7174424713469 | -122.482232418553 | (37.7174424713469, -122.482232418553) | 1 | 8 | 4 | 64 | 14 | ||
145333 | 288 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990528.50995 | 2093780.04307 | 37.7285763168388 | -122.475022533176 | (37.7285763168388, -122.475022533176) | 1 | 8 | 4 | 64 | 14 | ||
145554 | 110237 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Winston Dr | 3 | Median : Cutout | Tree | DPW 1 | 11 | 6x18 | 5989487.17448 | 2093569.32772 | 37.7279373404144 | -122.47860704469 | (37.7279373404144, -122.47860704469) | 1 | 8 | 4 | 64 | 14 | |||
148223 | 178594 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3353 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990562.4926 | 2094408.14654 | 37.7303029000397 | -122.474950884197 | (37.7303029000397, -122.474950884197) | 1 | 8 | 4 | 64 | 14 | |||
149777 | 256440 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3001 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5984950 | 2095029 | 37.7316807417675 | -122.494399498116 | (37.7316807417675, -122.494399498116) | 1 | 8 | 4 | 64 | 35 | ||||
150801 | 178598 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200 Winston Dr | 4 | : | Tree | Private 2 | 4 | Width 0ft | 5989486.74208 | 2093594.0787 | 37.7280052752208 | -122.478610348783 | (37.7280052752208, -122.478610348783) | 1 | 8 | 4 | 64 | 14 | |||
151463 | 243 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3027 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.3262 | 2095031.59495 | 37.7320135050113 | -122.475069552433 | (37.7320135050113, -122.475069552433) | 1 | 8 | 4 | 64 | 35 | ||
151818 | 230 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2975 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2 | 5990529.53728 | 2095454.90941 | 37.7331751359068 | -122.475141200505 | (37.7331751359068, -122.475141200505) | 1 | 8 | 4 | 64 | 35 | |||
152708 | 178595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3353 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990558.26669 | 2094238.61672 | 37.7298371690359 | -122.474953123505 | (37.7298371690359, -122.474953123505) | 1 | 8 | 4 | 64 | 14 | |||
153638 | 12453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Lake Merced Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | 1 | 8 | 4 | 64 | 35 | |||
161054 | 256439 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3001 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5984950 | 2095029 | 37.7316807417675 | -122.494399498116 | (37.7316807417675, -122.494399498116) | 1 | 8 | 4 | 64 | 35 | ||||
162804 | 256442 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3001 Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5984950 | 2095029 | 37.7316807417675 | -122.494399498116 | (37.7316807417675, -122.494399498116) | 1 | 8 | 4 | 64 | 35 | ||||
168096 | 256438 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3001 Sunset Blvd | 26 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
175909 | 111092 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333 | 2089769 | 37.7174355256527 | -122.48231868452 | (37.7174355256527, -122.48231868452) | 1 | 8 | 4 | 64 | 14 | |||
176572 | 178602 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 654 Brotherhood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990447.2893 | 2088474.31285 | 37.7140033930131 | -122.474916187436 | (37.7140033930131, -122.474916187436) | 1 | 8 | 4 | 64 | 14 | |||
180309 | 178591 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 67 Belle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5991713.92465 | 2086485.44715 | 37.7086157704667 | -122.470393502266 | (37.7086157704667, -122.470393502266) | 9 | 8 | 4 | 64 | 24 | |||
182910 | 254780 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 700 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
183214 | 286 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.76855 | 2093845.07208 | 37.7287551748878 | -122.475009099088 | (37.7287551748878, -122.475009099088) | 1 | 8 | 4 | 64 | 14 | ||
185047 | 275 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3210 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990662.18152 | 2094375.08558 | 37.7302178997362 | -122.474603837613 | (37.7302178997362, -122.474603837613) | 9 | 8 | 4 | 64 | 40 | ||
185239 | 223 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2956 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1995 12:00:00 AM | 20 | 2X3 | 5990609.51977 | 2095500.94473 | 37.733306172547 | -122.474868041348 | (37.733306172547, -122.474868041348) | 1 | 8 | 4 | 64 | 40 | ||
186011 | 413 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3854 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1994 12:00:00 AM | 8 | 2X3 | 5990824.06176 | 2090161.99601 | 37.7186591841634 | -122.473736974794 | (37.7186591841634, -122.473736974794) | 9 | 8 | 4 | 64 | 40 | ||
186306 | 178592 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 67 Belle Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5991724.32675 | 2086485.22811 | 37.7086157704725 | -122.470357535671 | (37.7086157704725, -122.470357535671) | 9 | 8 | 4 | 64 | 24 | |||
187540 | 249 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3060 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1994 12:00:00 AM | 7 | 2 | 5990633.95882 | 2094848.41631 | 37.7315159110224 | -122.474735939922 | (37.7315159110224, -122.474735939922) | 1 | 8 | 4 | 64 | 40 | ||
187573 | 113363 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 126 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x6 | Permit Number 776810 | 5991720.20644 | 2088367.09772 | 37.7137826921811 | -122.470508741378 | (37.7137826921811, -122.470508741378) | 9 | 8 | 6 | 64 | 24 | ||
188880 | 290 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3355 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2017 12:00:00 AM | 25 | 2X2 | 5990524.87284 | 2093730.45836 | 37.7284399589177 | -122.47503148863 | (37.7284399589177, -122.47503148863) | 1 | 8 | 4 | 64 | 14 | ||
191548 | 1306 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4001 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X6 | 5991941.83628 | 2087094.05513 | 37.7103000369794 | -122.469650093897 | (37.7103000369794, -122.469650093897) | 9 | 8 | 4 | 64 | 24 | |||
191962 | 178606 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989765.07873 | 2089203.5232 | 37.7159660653632 | -122.477327400255 | (37.7159660653632, -122.477327400255) | 1 | 8 | 4 | 64 | 14 | ||||
193816 | 226 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | 1 | 8 | 4 | 64 | 35 | |||
6381 | 118299 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
8108 | 212799 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 69 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1992 12:00:00 AM | 13 | Width 3ft | Permit Number 31026 | 5999569.71459 | 2093758.06013 | 37.7290357939629 | -122.44376510799 | (37.7290357939629, -122.44376510799) | 9 | 7 | 4 | 63 | 40 | |
8408 | 238633 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 19 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6003671.18134 | 2096664.0864 | 37.7372481708565 | -122.429793216401 | (37.7372481708565, -122.429793216401) | 2 | 7 | 5 | 63 | 7 | |||
11304 | 118290 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
15335 | 5751 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1790 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 12 | 3X3 | 6005296.84578 | 2097947.10293 | 37.7408629688522 | -122.424263766259 | (37.7408629688522, -122.424263766259) | 2 | 7 | 5 | 63 | 7 | ||
17610 | 105076 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 MATEO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6003644.6 | 2096720.9 | 37.7374026627639 | -122.429889171598 | (37.7374026627639, -122.429889171598) | 2 | 7 | 5 | 63 | 7 | |||
20921 | 118291 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 |
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) );