trees
1,650 rows where qSpecies_id = 64 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181860 | 245509 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 107 Valley St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6005195.41877 | 2099296.09974 | 37.7445612796971 | -122.424710405556 | (37.7445612796971, -122.424710405556) | 2 | 7 | 5 | 63 | 22 | |||
181829 | 182912 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2650 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982509.869 | 2096517.4169 | 37.735624423784 | -122.502945525702 | (37.735624423784, -122.502945525702) | 1 | 8 | 3 | 29491 | 35 | |||
181790 | 189337 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017665.54346 | 2096637.99611 | 37.7379590696539 | -122.381405965317 | (37.7379590696539, -122.381405965317) | 10 | 3 | 8 | 58 | 1 | |||
181702 | 245644 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3389 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 23 | Width 3ft | 6005789.06956 | 2103129.90059 | 37.7551215274464 | -122.42293010315 | (37.7551215274464, -122.42293010315) | 2 | 4 | 5 | 28859 | 19 | |||
181685 | 175948 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 333 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004505.96243 | 2092990.03512 | 37.7272072851728 | -122.426645440842 | (37.7272072851728, -122.426645440842) | 9 | 7 | 6 | 28861 | 5 | |||
181555 | 245556 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 939 Valencia St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 2ft | 6006339.41374 | 2104105.60149 | 37.7578316146567 | -122.421096125611 | (37.7578316146567, -122.421096125611) | 2 | 4 | 7 | 28859 | 19 | |||
181286 | 245546 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2020 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008044.42407 | 2106623.57699 | 37.7648413632549 | -122.415377725203 | (37.7648413632549, -122.415377725203) | 8 | 4 | 7 | 28859 | 19 | |||
181180 | 118016 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 484 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5984417.72759 | 2112558.11537 | 37.7797796561099 | -122.497533335153 | (37.7797796561099, -122.497533335153) | 11 | 6 | 2 | 55 | 26 | |||
180803 | 205430 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 965 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998406.65668 | 2095666.59634 | 37.7342097762612 | -122.447923224176 | (37.7342097762612, -122.447923224176) | 9 | 7 | 4 | 59 | 40 | |||
180781 | 68303 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2110 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2012 12:00:00 AM | 1 | Permit Number 771923 | 5981408.8137 | 2100678.9898 | 37.7469861733971 | -122.507060845065 | (37.7469861733971, -122.507060845065) | 1 | 8 | 3 | 29491 | 35 | |
180761 | 245625 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 322 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006447.43979 | 2097171.37864 | 37.7387979050978 | -122.420230391417 | (37.7387979050978, -122.420230391417) | 2 | 7 | 7 | 28859 | 2 | |||
180733 | 27694 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 600X El Camino Del Mar | 8 | Median : Cutout | Tree | DPW 1 | 3 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
180605 | 245708 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3710 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003620.6721 | 2103639.52756 | 37.7563982490915 | -122.430465410177 | (37.7563982490915, -122.430465410177) | 2 | 4 | 5 | 28862 | 3 | |||
180563 | 205437 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 378 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5999592.14359 | 2094987.68383 | 37.7324133328122 | -122.443775873778 | (37.7324133328122, -122.443775873778) | 9 | 7 | 4 | 63 | 40 | ||||
180501 | 182213 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2730 Lawton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 5985735.4613 | 2104364.4813 | 37.7573593930587 | -122.492371241702 | (37.7573593930587, -122.492371241702) | 1 | 8 | 3 | 56 | 35 | |||
180443 | 245496 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 115 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005419.88698 | 2103014.70044 | 37.7547843761167 | -122.424198652639 | (37.7547843761167, -122.424198652639) | 2 | 4 | 5 | 28859 | 19 | |||
180407 | 118439 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5201 Anza St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5982517.77201 | 2111663.67845 | 37.7772122457156 | -122.504039734844 | (37.7772122457156, -122.504039734844) | 11 | 6 | 2 | 55 | 26 | |||
180374 | 247678 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 5 | : | Tree | Private 2 | 13 | Width 4ft | 6000000.32593 | 2108756.30606 | 37.7702419045662 | -122.443353307504 | (37.7702419045662, -122.443353307504) | 15 | 5 | 11 | 29492 | 9 | |||
180318 | 245591 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3932 22nd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 4ft | 6002260.1918 | 2102976.44983 | 37.7545004349537 | -122.435122997251 | (37.7545004349537, -122.435122997251) | 2 | 4 | 5 | 28862 | 22 | |||
180244 | 245673 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005908.33244 | 2099840.79063 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) | 2 | 7 | 5 | 28859 | 22 | |||
179965 | 205327 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 218 Thrift St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5994824.42193 | 2089656.95499 | 37.7175033403925 | -122.459872882235 | (37.7175033403925, -122.459872882235) | 9 | 8 | 6 | 28861 | 24 | |||
179934 | 186320 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1800 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984982.8796 | 2102861.3111 | 37.7531880757132 | -122.494863100231 | (37.7531880757132, -122.494863100231) | 1 | 8 | 3 | 56 | 35 | |||
179891 | 189375 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017840.00731 | 2096483.57159 | 37.7375446809316 | -122.380792019749 | (37.7375446809316, -122.380792019749) | 10 | 3 | 8 | 58 | 1 | |||
179858 | 245554 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 939 Valencia St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6006339.99922 | 2104098.08411 | 37.7578110066823 | -122.421093567011 | (37.7578110066823, -122.421093567011) | 2 | 4 | 7 | 28859 | 19 | |||
179727 | 245748 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 172 States St | 2 | Front Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6001078.73649 | 2106349.47009 | 37.7636947672237 | -122.439450543926 | (37.7636947672237, -122.439450543926) | 15 | 5 | 5 | 28862 | 3 | |||
179598 | 245720 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2423 Market St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6002197.83502 | 2105837.54204 | 37.7623527628852 | -122.435543309786 | (37.7623527628852, -122.435543309786) | 15 | 4 | 5 | 28862 | 3 | |||
179539 | 189346 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017783.39859 | 2096513.49577 | 37.7376237223681 | -122.380989824718 | (37.7376237223681, -122.380989824718) | 10 | 3 | 8 | 58 | 1 | |||
179509 | 182795 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1781 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988419.6712 | 2103186.0764 | 37.7542803738164 | -122.483001929305 | (37.7542803738164, -122.483001929305) | 1 | 8 | 3 | 56 | 35 | |||
179469 | 118544 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5981537.23315 | 2112382.31128 | 37.7791276891 | -122.507485005709 | (37.7791276891, -122.507485005709) | 11 | 6 | 2 | 55 | 26 | |||
179462 | 175928 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001160.91031 | 2092287.39033 | 37.7250883007811 | -122.43815892321 | (37.7250883007811, -122.43815892321) | 9 | 7 | 6 | 28861 | 25 | |||
179381 | 205452 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 142 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6001112.57184 | 2094702.00042 | 37.7317155173367 | -122.438498946978 | (37.7317155173367, -122.438498946978) | 9 | 7 | 4 | 63 | 40 | |||
179360 | 118632 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 349 Point Lobos Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5981625.79815 | 2112645.61268 | 37.7798558535661 | -122.507198167376 | (37.7798558535661, -122.507198167376) | 11 | 6 | 2 | 55 | 26 | |||
179302 | 184677 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3313 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983985.0135 | 2104248.1551 | 37.7569375007353 | -122.498416295287 | (37.7569375007353, -122.498416295287) | 1 | 8 | 3 | 56 | 35 | |||
179187 | 245687 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 587 Sanchez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003680.84231 | 2104863.20813 | 37.7597615930527 | -122.4303446231 | (37.7597615930527, -122.4303446231) | 2 | 4 | 5 | 28862 | 3 | |||
179058 | 175878 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | 9 | 7 | 8 | 309 | 39 | |||
179001 | 53460 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 680 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 6368 | 6009737.89629686 | 2098146.39720808 | 37.7416599538103 | -122.408922259193 | (37.7416599538103, -122.408922259193) | 10 | 7 | 7 | 28859 | 2 | ||
178880 | 189349 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017793.56519 | 2096439.47156 | 37.737421027763 | -122.380949528792 | (37.737421027763, -122.380949528792) | 10 | 3 | 8 | 58 | 1 | |||
178736 | 126065 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1920 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6000989.06632 | 2121021.48883 | 37.8039752632199 | -122.440813227268 | (37.8039752632199, -122.440813227268) | 13 | 9 | 1 | 57 | 17 | |||
178715 | 108601 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
178664 | 254577 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1312 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781495 | 5981841.16321 | 2106144.39254 | 37.7620180770477 | -122.505970991836 | (37.7620180770477, -122.505970991836) | 1 | 8 | 3 | 56 | 35 |
178546 | 245623 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 67 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007744.29086 | 2100021.77176 | 37.7466974402359 | -122.415948270391 | (37.7466974402359, -122.415948270391) | 2 | 7 | 7 | 28859 | 2 | |||
178269 | 122626 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613 | 2095517 | 37.7330009316807 | -122.495600537949 | (37.7330009316807, -122.495600537949) | 1 | 8 | 4 | 64 | 35 | |
178258 | 245754 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 103 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003339.23771 | 2108603.67132 | 37.7700126439943 | -122.43179313686 | (37.7700126439943, -122.43179313686) | 15 | 9 | 5 | 29492 | 9 | |||
178087 | 122296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1799 Cabrillo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5990085.59 | 2110638.88168 | 37.7748405619036 | -122.477785590315 | (37.7748405619036, -122.477785590315) | 11 | 6 | 2 | 55 | 26 | |||
177600 | 189339 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017687.84248 | 2096619.53087 | 37.7379095988488 | -122.381327582209 | (37.7379095988488, -122.381327582209) | 10 | 3 | 8 | 58 | 1 | |||
177575 | 245484 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 336 Elsie St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6006438.81302 | 2097168.74842 | 37.7387901970012 | -122.420260032173 | (37.7387901970012, -122.420260032173) | 2 | 7 | 7 | 28859 | 2 | |||
177510 | 245524 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 905 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5998710.43294 | 2106861.68994 | 37.7649661271206 | -122.447678613073 | (37.7649661271206, -122.447678613073) | 15 | 5 | 11 | 29492 | 9 | |||
177442 | 245745 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 152 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999827.83204 | 2106019.22955 | 37.7627167392176 | -122.443753293574 | (37.7627167392176, -122.443753293574) | 15 | 5 | 5 | 28862 | 3 | |||
177157 | 245579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2211 Castro St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 34 | Width 10ft | 6002722.73971 | 2099078.10781 | 37.743822760922 | -122.433244852161 | (37.743822760922, -122.433244852161) | 2 | 7 | 5 | 63 | 22 | |||
177086 | 245746 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4341 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000555.00731 | 2105763.71254 | 37.7620566017498 | -122.44121992587 | (37.7620566017498, -122.44121992587) | 15 | 5 | 5 | 28862 | 3 | |||
176990 | 183530 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2575 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5988604.9156 | 2097798.7464 | 37.7394989682195 | -122.481966694555 | (37.7394989682195, -122.481966694555) | 1 | 8 | 3 | 29491 | 35 | |||
176440 | 252990 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 52 Pierce St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x8 | 6002925 | 2108585 | 37.7699378868501 | -122.433224642796 | (37.7699378868501, -122.433224642796) | 15 | 5 | 5 | 29492 | 9 | ||||
176410 | 118134 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3309 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5985300.93469 | 2111081.99848 | 37.7757783921553 | -122.494369139944 | (37.7757783921553, -122.494369139944) | 11 | 6 | 2 | 55 | 26 | |||
176370 | 189334 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 27 | Median : Yard | Tree | DPW 1 | 17 | 6016143.04506 | 2096752.08346 | 37.7381881584664 | -122.386677993501 | (37.7381881584664, -122.386677993501) | 10 | 3 | 8 | 58 | 1 | ||||
176142 | 245548 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1187 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007688.25506 | 2102766.23628 | 37.7542299692468 | -122.41633639261 | (37.7542299692468, -122.41633639261) | 2 | 4 | 7 | 28859 | 19 | |||
175993 | 245585 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 229 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6000632.73425 | 2103024.67121 | 37.7545402911131 | -122.440754615747 | (37.7545402911131, -122.440754615747) | 2 | 4 | 5 | 28862 | 22 | |||
175992 | 189343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017750.34235 | 2096562.27095 | 37.7377558246748 | -122.381107507305 | (37.7377558246748, -122.381107507305) | 10 | 3 | 8 | 58 | 1 | |||
175753 | 126108 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2501 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999653.99691 | 2117501.26675 | 37.7942335504827 | -122.445180067106 | (37.7942335504827, -122.445180067106) | 13 | 9 | 1 | 57 | 27 | |||
175723 | 30013 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 738X San Jose Ave | 5 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005738.10231 | 2098921.33618 | 37.7435628991021 | -122.422807283651 | (37.7435628991021, -122.422807283651) | 2 | 7 | 7 | 28859 | 2 | ||
175587 | 68987 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | 13 | 9 | 1 | 57 | 17 | |
175498 | 205399 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5 Sequoia Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998224.97973 | 2097769.14697 | 37.7399724907268 | -122.448702722352 | (37.7399724907268, -122.448702722352) | 9 | 7 | 4 | 59 | 40 | |||
175483 | 118128 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3395 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5985149.90353 | 2111077.69169 | 37.7757577271217 | -122.49489126952 | (37.7757577271217, -122.49489126952) | 11 | 6 | 2 | 55 | 26 | |||
175475 | 175921 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3014 22nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5989750.67751 | 2095205.86942 | 37.7324461634578 | -122.477815700639 | (37.7324461634578, -122.477815700639) | 1 | 8 | 4 | 64 | 35 | |||
175332 | 175905 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 205 Nueva Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6012845.81254 | 2086882.70524 | 37.7109057537785 | -122.397386329935 | (37.7109057537785, -122.397386329935) | 10 | 3 | 8 | 309 | 1 | |||
175274 | 247868 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 397 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 4 | 6009691.89213 | 2098418.67435 | 37.7424049905119 | -122.409100534686 | (37.7424049905119, -122.409100534686) | 10 | 7 | 7 | 28859 | 2 | ||||
175175 | 117794 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3775 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5983909.70372 | 2111029.86966 | 37.7755537454696 | -122.499177830631 | (37.7755537454696, -122.499177830631) | 11 | 6 | 2 | 55 | 26 | |||
175171 | 118141 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3338 Balboa St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5985127.87528 | 2111128.85384 | 37.775896914237 | -122.494971242941 | (37.775896914237, -122.494971242941) | 11 | 6 | 2 | 55 | 26 | |||
175161 | 118494 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981369.73448 | 2112312.23583 | 37.778925414411 | -122.508059239406 | (37.778925414411, -122.508059239406) | 11 | 6 | 2 | 55 | 26 | ||||
174996 | 89573 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4901X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983409.0007 | 2111692.01023 | 37.7773424056819 | -122.50095883592 | (37.7773424056819, -122.50095883592) | 11 | 6 | 2 | 55 | 26 | ||
174880 | 187561 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 136 Alpha St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010941.11015 | 2088158.68343 | 37.7143031001696 | -122.404059202394 | (37.7143031001696, -122.404059202394) | 9 | 7 | 8 | 309 | 39 | ||||
174766 | 126129 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2800x Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | 5 | 9 | 1 | 28858 | 32 | |||
174461 | 187502 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 8 | Front Yard : Yard | Tree | Private 2 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | 9 | 7 | 6 | 309 | 5 | ||||
173915 | 205283 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 5994526.48433 | 2100257.05726 | 37.7465914866063 | -122.461670832968 | (37.7465914866063, -122.461670832968) | 1 | 8 | 4 | 29491 | 40 | |||
173821 | 205246 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1518 17th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5990890.58105 | 2105042.0422 | 37.7595198346025 | -122.474592431492 | (37.7595198346025, -122.474592431492) | 1 | 8 | 4 | 56 | 12 | |||
173774 | 181439 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1395 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981197.3238 | 2105634.1509 | 37.760579181106 | -122.50815986988 | (37.760579181106, -122.50815986988) | 1 | 8 | 3 | 56 | 35 | |||
173630 | 189351 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017770.46268 | 2096373.7262 | 37.7372392289147 | -122.381024836236 | (37.7372392289147, -122.381024836236) | 10 | 3 | 8 | 58 | 1 | |||
173517 | 205343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Junipero Serra Blvd | 33 | : | Tree | Private 2 | 9 | Width 0ft | 5991382.87064 | 2094419.86575 | 37.7303825871646 | -122.472115606868 | (37.7303825871646, -122.472115606868) | 9 | 8 | 4 | 64 | 40 | |||
173459 | 65584 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1990 12:00:00 AM | 1 | Permit Number 28484 | 6004276.22204 | 2093135.2738 | 37.7275930871392 | -122.427449994148 | (37.7275930871392, -122.427449994148) | 9 | 7 | 6 | 28861 | 5 | ||
173453 | 205473 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5999475.64233 | 2093531.527 | 37.7284084205947 | -122.44407405119 | (37.7284084205947, -122.44407405119) | 9 | 7 | 4 | 63 | 40 | ||||
173446 | 183686 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1319 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5984282.0441 | 2106184.7768 | 37.7622723352997 | -122.497532043867 | (37.7622723352997, -122.497532043867) | 1 | 8 | 3 | 56 | 35 | |||
173425 | 175937 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 17 Paulding St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000256.08856 | 2093171.84167 | 37.7274652988843 | -122.441350220534 | (37.7274652988843, -122.441350220534) | 9 | 7 | 6 | 28861 | 25 | |||
173418 | 182309 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2845 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5985936.0868 | 2104997.0895 | 37.7591080879753 | -122.491723977653 | (37.7591080879753, -122.491723977653) | 1 | 8 | 3 | 56 | 35 | |||
173396 | 245690 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 224 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001079.74999 | 2105041.32334 | 37.7601029748049 | -122.439353265163 | (37.7601029748049, -122.439353265163) | 2 | 4 | 5 | 28862 | 3 | |||
173370 | 245557 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 939 Valencia St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6006339.4561 | 2104107.66472 | 37.7578372821949 | -122.421096125609 | (37.7578372821949, -122.421096125609) | 2 | 4 | 7 | 28859 | 19 | |||
173365 | 245768 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 50 Digby St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6002895.54677 | 2097597.39943 | 37.7397668805496 | -122.432541584154 | (37.7397668805496, -122.432541584154) | 2 | 7 | 5 | 63 | 7 | |||
173324 | 186127 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1700 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984963.9795 | 2103111.9591 | 37.7538751796742 | -122.494946939461 | (37.7538751796742, -122.494946939461) | 1 | 8 | 3 | 56 | 35 | |||
173121 | 245775 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 395 Addison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002128.55663 | 2097690.46985 | 37.7399789056026 | -122.435200162657 | (37.7399789056026, -122.435200162657) | 2 | 7 | 5 | 63 | 7 | ||||
172674 | 253838 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 5.5x4 | Permit Number 781496 | 5981900 | 2105162 | 37.7593241709496 | -122.505694672765 | (37.7593241709496, -122.505694672765) | 1 | 8 | 3 | 56 | 35 |
172417 | 245586 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4321 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000940.18766 | 2103282.33265 | 37.7552652714942 | -122.439709834659 | (37.7552652714942, -122.439709834659) | 2 | 4 | 5 | 28862 | 22 | |||
172280 | 52223 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1331 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | 6 | Permit Number 48403 | 6006656.01014 | 2118694.90131 | 37.7979081488955 | -122.421037065315 | (37.7979081488955, -122.421037065315) | 13 | 9 | 10 | 28858 | 32 | ||
171963 | 245486 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 San Jose Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006168.67075 | 2101144.6213 | 37.7496918193421 | -122.421476344562 | (37.7496918193421, -122.421476344562) | 2 | 4 | 5 | 28859 | 19 | |||
171869 | 205274 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1480 10th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993070.14394 | 2105443.29293 | 37.7607476115304 | -122.467083659878 | (37.7607476115304, -122.467083659878) | 1 | 8 | 4 | 56 | 12 | |||
171821 | 245739 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2532 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001195.64447 | 2107368.90834 | 37.7665005458886 | -122.439119265138 | (37.7665005458886, -122.439119265138) | 15 | 5 | 5 | 28862 | 3 | |||
171710 | 175894 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002021.18873 | 2090405.02227 | 37.7199686303329 | -122.435050469629 | (37.7199686303329, -122.435050469629) | 9 | 7 | 6 | 28861 | 5 | |||
171618 | 118115 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3521 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5984646.98456 | 2111057.4205 | 37.7756726158346 | -122.496629470062 | (37.7756726158346, -122.496629470062) | 11 | 6 | 2 | 55 | 26 | |||
171452 | 46164 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 553 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44494 | 5996949.78101651 | 2107345.31191782 | 37.7661932466683 | -122.453803159566 | (37.7661932466683, -122.453803159566) | 15 | 5 | 11 | 29492 | 12 | ||
171373 | 201489 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 404 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6018812.86035 | 2095041.80461 | 37.7336395152478 | -122.37732835733 | (37.7336395152478, -122.37732835733) | 10 | 3 | 8 | 58 | 1 | ||||
171367 | 184182 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1618 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5980983.7076 | 2104008.48 | 37.7561029646501 | -122.508777956978 | (37.7561029646501, -122.508777956978) | 1 | 8 | 3 | 56 | 35 | |||
171353 | 175933 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 48 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000928.87779 | 2093144.53225 | 37.7274286173327 | -122.439022434243 | (37.7274286173327, -122.439022434243) | 9 | 7 | 6 | 28861 | 25 | ||||
171202 | 117092 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2X 09TH AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 3x3 | 5993083 | 2114893 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | 11 | 6 | 1 | 54 | 11 |
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) );