trees
395 rows where qSpecies_id = 35 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33869 | 186381 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1801 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984844.8943 | 2102435.3563 | 37.7520104429492 | -122.495308863381 | (37.7520104429492, -122.495308863381) | 1 | 8 | 3 | 56 | 35 | |||
34002 | 211012 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 35 | : | Tree | Private 2 | 3 | Width 0ft | 5991334.38006 | 2093575.3838 | 37.7280610448729 | -122.472221709761 | (37.7280610448729, -122.472221709761) | 9 | 8 | 4 | 64 | 40 | |||
36557 | 211039 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | 9 | 7 | 5 | 63 | 7 | ||||
37212 | 111553 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 31 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
37951 | 178151 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 4 | : | Tree | Private 2 | 3 | Width 0ft | 5993597.52442 | 2087641.38278 | 37.7118984245322 | -122.463967443352 | (37.7118984245322, -122.463967443352) | 9 | 8 | 4 | 64 | 24 | |||
38568 | 8471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.7838791576421 | -122.43635890448 | (37.7838791576421, -122.43635890448) | 13 | 5 | 11 | 29490 | 41 | ||
38569 | 181557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984875.8554 | 2106073.5142 | 37.7620016277453 | -122.495470098326 | (37.7620016277453, -122.495470098326) | 1 | 8 | 3 | 56 | 35 | |||
38732 | 186685 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1401 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984734.6622 | 2105357.4834 | 37.7600273389586 | -122.495905599978 | (37.7600273389586, -122.495905599978) | 1 | 8 | 3 | 56 | 35 | |||
39027 | 211036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | 2 | 7 | 5 | 63 | 7 | ||||
39660 | 111514 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
39949 | 8349 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 15 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
40576 | 120625 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6004349 | 2113949 | 37.7847467885767 | -122.428681484586 | (37.7847467885767, -122.428681484586) | 13 | 9 | 11 | 29490 | 41 | |||||
40897 | 21491 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
41737 | 115997 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20X Park St | 2 | Median : Yard | Tree | DPW 1 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | |||
41763 | 114139 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
41826 | 187121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985174.7424 | 2097328.4139 | 37.7380074703554 | -122.493791914706 | (37.7380074703554, -122.493791914706) | 1 | 8 | 3 | 29491 | 35 | |||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
43907 | 8339 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
43976 | 178156 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 11 | : | Tree | Private 2 | 5 | Width 0ft | 5993327.47852 | 2087822.82752 | 37.712381061909 | -122.464913959129 | (37.712381061909, -122.464913959129) | 9 | 8 | 4 | 64 | 24 | |||
45135 | 111279 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 24 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
45559 | 8390 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.7849237683164 | -122.428202546761 | (37.7849237683164, -122.428202546761) | 13 | 9 | 11 | 29490 | 41 | |||
47104 | 187385 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985037.3743 | 2100116.159 | 37.7456538284953 | -122.494472302074 | (37.7456538284953, -122.494472302074) | 1 | 8 | 3 | 29491 | 35 | |||
49277 | 211023 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 83 | : | Tree | Private 2 | 5 | Width 0ft | 5991239.95465 | 2092188.59606 | 37.7242478060794 | -122.472447079879 | (37.7242478060794, -122.472447079879) | 9 | 8 | 4 | 64 | 40 | |||
49351 | 21431 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
49587 | 178167 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 22 | : | Tree | Private 2 | 5 | Width 0ft | 5992858.09731 | 2087851.49534 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | 9 | 8 | 4 | 64 | 24 | |||
49925 | 211004 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | 1 | 7 | 4 | 59 | 40 | |||
49956 | 211007 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Bosworth St | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6002197.80666 | 2095393.39137 | 37.7336755906519 | -122.43479650017 | (37.7336755906519, -122.43479650017) | 9 | 7 | 5 | 63 | 40 | |||
51083 | 178139 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5992188.74587 | 2087889.24466 | 37.7124977039766 | -122.468854559004 | (37.7124977039766, -122.468854559004) | 9 | 8 | 4 | 64 | 24 | |||
51793 | 211027 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 157 | : | Tree | Private 2 | 4 | Width 0ft | 5991179.7136 | 2091396.79999 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | 9 | 8 | 4 | 64 | 40 | |||
52379 | 178161 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 16 | : | Tree | Private 2 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.465679708459 | (37.7124525633948, -122.465679708459) | 9 | 8 | 4 | 64 | 24 | |||
52814 | 211034 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995115.07777 | 2100328.51022 | 37.7468215422 | -122.45964072765 | (37.7468215422, -122.45964072765) | 1 | 8 | 4 | 59 | 40 | |||
53240 | 185023 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985046.088 | 2096329.59 | 37.7352574390957 | -122.494163132435 | (37.7352574390957, -122.494163132435) | 1 | 8 | 3 | 29491 | 35 | |||
53879 | 114377 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
54367 | 253555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 27 Ceres St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | ||||
54454 | 200536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191 | (37.7352092330314, -122.38648971191) | 10 | 3 | 8 | 58 | 1 | |||
54682 | 8393 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | 13 | 9 | 11 | 29490 | 41 | |||
54931 | 200542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 18 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016191.4179 | 2095647.8311 | 37.7351587822654 | -122.38643377144 | (37.7351587822654, -122.38643377144) | 10 | 3 | 8 | 58 | 1 | |||
55245 | 186890 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.262 | 2096503.3044 | 37.7357434330648 | -122.493642900348 | (37.7357434330648, -122.493642900348) | 1 | 8 | 3 | 29491 | 35 | |||
56939 | 185562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984881.299 | 2099768.8111 | 37.7446909699364 | -122.494986371806 | (37.7446909699364, -122.494986371806) | 1 | 8 | 3 | 29491 | 35 | |||
57367 | 132164 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 6011515.19186 | 2120799.84951 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | 3 | 1 | 10 | 28860 | 6 | |||
58106 | 132162 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 165 Francisco St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.407713714409 | (37.8053168133783, -122.407713714409) | 3 | 1 | 10 | 308 | 23 | ||||
60102 | 185310 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.2385 | 2097256.121 | 37.7377965384833 | -122.494521307154 | (37.7377965384833, -122.494521307154) | 1 | 8 | 3 | 29491 | 35 | |||
60514 | 8341 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
61085 | 114124 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
61408 | 186038 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984981.8854 | 2102120.1374 | 37.7511529582795 | -122.494811896529 | (37.7511529582795, -122.494811896529) | 1 | 8 | 3 | 29491 | 35 | |||
62488 | 200617 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 58 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | 10 | 3 | 8 | 58 | 1 | |||
63063 | 139214 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 8 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6004809.3749 | 2114055.503 | 37.7850652633568 | -122.427096327106 | (37.7850652633568, -122.427096327106) | 13 | 9 | 11 | 28858 | 41 | |||
63516 | 178176 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989163.89955 | 2089384.56057 | 37.7164282485354 | -122.479418571325 | (37.7164282485354, -122.479418571325) | 1 | 8 | 4 | 64 | 14 | ||||
65012 | 254798 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 700 Brotherhood Way | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
65234 | 8577 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.7831949132778 | -122.440376203878 | (37.7831949132778, -122.440376203878) | 15 | 5 | 11 | 29490 | 41 | |||
65461 | 185709 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.494940652646 | (37.7464914545154, -122.494940652646) | 1 | 8 | 3 | 29491 | 35 | |||
65641 | 139330 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 4 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6005126.2471 | 2114101.4827 | 37.7852094256692 | -122.426003322666 | (37.7852094256692, -122.426003322666) | 13 | 9 | 11 | 28858 | 41 | |||
65698 | 8391 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949 | -122.428376269712 | (37.784906265949, -122.428376269712) | 13 | 9 | 11 | 29490 | 41 | |||
66177 | 109347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 59x BURNSIDE AVE | 1 | Median : Yard | Tree | DPW 1 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | 2 | 7 | 5 | 63 | 7 | ||||
66301 | 178130 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 1 | : | Tree | Private 2 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | 9 | 8 | 4 | 64 | 24 | |||
66433 | 8563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
66990 | 98838 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5994967.95791 | 2097979.30417 | 37.740362747151 | -122.459979297607 | (37.740362747151, -122.459979297607) | 9 | 8 | 4 | 59 | 40 | |||
67047 | 186733 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1250 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984855.8629 | 2106397.0571 | 37.7628888152225 | -122.495563108047 | (37.7628888152225, -122.495563108047) | 1 | 8 | 3 | 56 | 35 | |||
67535 | 211010 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 27 | : | Tree | Private 2 | 3 | Width 0ft | 5991339.10103 | 2093646.61822 | 37.7282569100089 | -122.472210579766 | (37.7282569100089, -122.472210579766) | 9 | 8 | 4 | 64 | 40 | |||
68405 | 185535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984921.0973 | 2100070.748 | 37.7455223363848 | -122.494871016971 | (37.7455223363848, -122.494871016971) | 1 | 8 | 3 | 29491 | 35 | |||
68490 | 243115 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 18 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001841.69539 | 2098643.31719 | 37.7425789076843 | -122.436260181872 | (37.7425789076843, -122.436260181872) | 2 | 7 | 5 | 63 | 7 | |||
68619 | 178132 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 3 | : | Tree | Private 2 | 6 | Width 0ft | 5992585.12632 | 2087848.18621 | 37.7124078599039 | -122.467481573927 | (37.7124078599039, -122.467481573927) | 9 | 8 | 4 | 64 | 24 | |||
69193 | 186380 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1801 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984843.2782 | 2102467.9478 | 37.7520998356184 | -122.495316855331 | (37.7520998356184, -122.495316855331) | 1 | 8 | 3 | 56 | 35 | |||
69254 | 111516 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 14 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
69447 | 111507 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
69893 | 211037 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6001183.29295 | 2095747.84811 | 37.7345911958118 | -122.438329349227 | (37.7345911958118, -122.438329349227) | 2 | 7 | 5 | 63 | 7 | ||||
71060 | 200527 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016132.8234 | 2095707.6369 | 37.7353197532414 | -122.386640524716 | (37.7353197532414, -122.386640524716) | 10 | 3 | 8 | 58 | 1 | |||
71095 | 178152 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 7 | : | Tree | Private 2 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.464231061624 | (37.7121347780763, -122.464231061624) | 9 | 8 | 4 | 64 | 24 | |||
71238 | 200528 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6016143.3115 | 2095696.7293 | 37.7352903838014 | -122.386603502798 | (37.7352903838014, -122.386603502798) | 10 | 3 | 8 | 58 | 1 | |||
71549 | 234477 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Grand View Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999979.48342 | 2101750.0189 | 37.7510031819599 | -122.442922193204 | (37.7510031819599, -122.442922193204) | 2 | 4 | 5 | 28862 | 22 | ||||
71757 | 8562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
72264 | 184348 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.7629746803622 | -122.496160108596 | (37.7629746803622, -122.496160108596) | 1 | 8 | 3 | 56 | 35 | |||
73905 | 8395 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004192.8617 | 2113973.9777 | 37.7848065332396 | -122.429223453232 | (37.7848065332396, -122.429223453232) | 13 | 9 | 11 | 29490 | 41 | ||
74434 | 120629 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6004538 | 2114050 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | 13 | 9 | 11 | 29490 | 13 | |||||
74880 | 8392 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004378.144 | 2113996.8521 | 37.7848798278423 | -122.428584068109 | (37.7848798278423, -122.428584068109) | 13 | 9 | 11 | 29490 | 41 | |||
75002 | 185676 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984839.349 | 2100771.308 | 37.7474410976212 | -122.495205338122 | (37.7474410976212, -122.495205338122) | 1 | 8 | 3 | 29491 | 35 | |||
75099 | 178157 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 12 | : | Tree | Private 2 | 7 | Width 0ft | 5993292.82373 | 2087832.959 | 37.712406882332 | -122.465034470985 | (37.712406882332, -122.465034470985) | 9 | 8 | 4 | 64 | 24 | |||
75630 | 184347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1251 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984658.9334 | 2106421.3632 | 37.7629440193232 | -122.496246001897 | (37.7629440193232, -122.496246001897) | 1 | 8 | 3 | 56 | 35 | |||
75828 | 114138 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/16/2016 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
76251 | 181473 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984918.4628 | 2105275.6702 | 37.7598134657238 | -122.49526389807 | (37.7598134657238, -122.49526389807) | 1 | 8 | 3 | 56 | 35 | |||
77378 | 211002 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996779.38475 | 2099373.51377 | 37.744294920285 | -122.453816791818 | (37.744294920285, -122.453816791818) | 1 | 7 | 4 | 59 | 40 | |||
79654 | 8340 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
80290 | 200146 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 6101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6013586.8559 | 2091305.2042 | 37.7230902914135 | -122.395134667477 | (37.7230902914135, -122.395134667477) | 10 | 3 | 8 | 58 | 1 | |||
82054 | 194426 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 5ft | 6007946.83693 | 2109121.10943 | 37.7716935173803 | -122.415892125715 | (37.7716935173803, -122.415892125715) | 8 | 2 | 9 | 28853 | 19 | |||
82197 | 114371 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988453 | 2089765 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | 1 | 8 | 4 | 64 | 14 | ||||
82660 | 27295 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 2 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.7792423135673 | -122.503361806845 | (37.7792423135673, -122.503361806845) | 11 | 6 | 2 | 55 | 26 | ||
82846 | 178140 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 11 | : | Tree | Private 2 | 6 | Width 0ft | 5992153.76433 | 2087899.91411 | 37.712524978625 | -122.468976240883 | (37.712524978625, -122.468976240883) | 9 | 8 | 4 | 64 | 24 | |||
83122 | 2045 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
83309 | 247525 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1101 Waller St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | 6000029.93527 | 2108491.27934 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | 15 | 5 | 11 | 29492 | 9 | ||||
83823 | 211035 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | 2 | 7 | 5 | 63 | 7 | ||||
84561 | 178158 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 13 | : | Tree | Private 2 | 5 | Width 0ft | 5993255.20411 | 2087840.25906 | 37.7124247572585 | -122.465165024673 | (37.7124247572585, -122.465165024673) | 9 | 8 | 4 | 64 | 24 | |||
86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
86690 | 200559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 35 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | 10 | 3 | 8 | 58 | 1 | |||
87580 | 178149 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 20 | : | Tree | Private 2 | 4 | Width 0ft | 5991654.66793 | 2087995.14516 | 37.712757610756 | -122.470708188538 | (37.712757610756, -122.470708188538) | 9 | 8 | 4 | 64 | 24 | |||
87610 | 185118 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.7343880441022 | -122.492171858431 | (37.7343880441022, -122.492171858431) | 1 | 8 | 3 | 29491 | 35 | |||
87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
88271 | 178133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 4 | : | Tree | Private 2 | 6 | Width 0ft | 5992553.46677 | 2087849.43624 | 37.7124094643071 | -122.467591088862 | (37.7124094643071, -122.467591088862) | 9 | 8 | 4 | 64 | 24 | |||
88362 | 178135 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 6 | : | Tree | Private 2 | 5 | Width 0ft | 5992385.69997 | 2087851.79588 | 37.7124062555186 | -122.468171108404 | (37.7124062555186, -122.468171108404) | 9 | 8 | 4 | 64 | 24 | |||
88636 | 186468 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.7556706898247 | -122.495627747424 | (37.7556706898247, -122.495627747424) | 1 | 8 | 3 | 56 | 35 | |||
88779 | 186421 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | 1 | 8 | 3 | 56 | 35 |
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) );