trees
395 rows where qSpecies_id = 35 sorted by Police Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65 | 264979 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
| 436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 4438 | 254757 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 13 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
| 21559 | 8344 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
| 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 | |||||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 63272 | 4532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6005027.0371 | 2113673.2533 | 37.784028006638 | -122.42631605912 | (37.784028006638, -122.42631605912) | 7 | 9 | 11 | 28858 | 41 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 94007 | 132160 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1141 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 20 | 6006382.37262 | 2120397.93248 | 37.8025688116636 | -122.422104980572 | (37.8025688116636, -122.422104980572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 94670 | 139359 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 9 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.427524533418 | (37.7850156556233, -122.427524533418) | 13 | 9 | 11 | 28858 | 41 | |||
| 97674 | 8394 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | 13 | 9 | 11 | 29490 | 41 | |||
| 110654 | 139356 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 5 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.7851754347521 | -122.426221023287 | (37.7851754347521, -122.426221023287) | 13 | 9 | 11 | 28858 | 41 | |||
| 125264 | 8348 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
| 127704 | 4530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | 7 | 9 | 11 | 28858 | 41 | |
| 137065 | 4531 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | 7 | 9 | 11 | 28858 | 41 | |
| 141285 | 120542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | DPW for City Agency | 6002644.10897 | 2115479.97736 | 37.7888538273233 | -122.434689351726 | (37.7888538273233, -122.434689351726) | 13 | 9 | 1 | 29490 | 27 | ||||
| 150152 | 120624 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 150834 | 8342 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
| 156411 | 120627 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
| 161286 | 8351 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 17 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
| 177341 | 139329 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.7852460889347 | -122.425761723999 | (37.7852460889347, -122.425761723999) | 13 | 9 | 11 | 28858 | 41 | |||
| 187582 | 139358 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 7 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6004934.0187 | 2114075.446 | 37.7851270694756 | -122.426666519258 | (37.7851270694756, -122.426666519258) | 13 | 9 | 11 | 28858 | 41 | |||
| 194127 | 122584 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2500X Lyon St | 4 | Median : Cutout | Tree | Private 2 | 11 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
| 450 | 178165 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 20 | Median : Cutout | Tree | Private 2 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | |||
| 5669 | 185954 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984829.7049 | 2101412.004 | 37.7491997090577 | -122.495285928093 | (37.7491997090577, -122.495285928093) | 1 | 8 | 3 | 29491 | 35 | |||
| 6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 6708 | 256455 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2901 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 7563 | 187388 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985049.5619 | 2100144.9354 | 37.7457335539505 | -122.49443228067 | (37.7457335539505, -122.49443228067) | 1 | 8 | 3 | 29491 | 35 | |||
| 9866 | 178155 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 10 | : | Tree | Private 2 | 6 | Width 0ft | 5993366.44396 | 2087810.43567 | 37.7123492834548 | -122.464778384525 | (37.7123492834548, -122.464778384525) | 9 | 8 | 4 | 64 | 24 | |||
| 10548 | 211015 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991307.93934 | 2093199.2311 | 37.7270266932138 | -122.472285706431 | (37.7270266932138, -122.472285706431) | 9 | 8 | 4 | 64 | 40 | |||
| 11755 | 186875 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | 1 | 8 | 3 | 29491 | 35 | |||
| 11838 | 94234 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 12887 | 185307 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984973.1253 | 2097316.8359 | 37.7379638824881 | -122.494488141215 | (37.7379638824881, -122.494488141215) | 1 | 8 | 3 | 29491 | 35 | |||
| 14478 | 211030 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 165 | : | Tree | Private 2 | 4 | Width 0ft | 5991183.72988 | 2091349.85826 | 37.7219415855123 | -122.472580317121 | (37.7219415855123, -122.472580317121) | 9 | 8 | 4 | 64 | 40 | |||
| 15433 | 186081 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1901 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984821.8866 | 2101948.8735 | 37.7506733477582 | -122.495352551899 | (37.7506733477582, -122.495352551899) | 1 | 8 | 3 | 29491 | 35 | |||
| 17565 | 181385 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984917.5854 | 2104501.8427 | 37.7576886993488 | -122.495209866912 | (37.7576886993488, -122.495209866912) | 1 | 8 | 3 | 56 | 35 | |||
| 18682 | 91505 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
| 19643 | 105261 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988914.8 | 2089258.8 | 37.7160684695332 | -122.48027037241 | (37.7160684695332, -122.48027037241) | 1 | 8 | 4 | 64 | 14 | |||||
| 20336 | 211013 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.472223101034 | (37.727880584217, -122.472223101034) | 9 | 8 | 4 | 64 | 40 | |||
| 22467 | 211031 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2375 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5992617.61467 | 2099318.2887 | 37.7439038024205 | -122.468203163863 | (37.7439038024205, -122.468203163863) | 1 | 8 | 4 | 29491 | 40 | |||
| 23338 | 114378 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
| 23395 | 185955 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2001 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984875.9978 | 2101408.1817 | 37.7491919243755 | -122.495125567093 | (37.7491919243755, -122.495125567093) | 1 | 8 | 3 | 29491 | 35 | |||
| 23532 | 211021 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 6 | Width 0ft | 5991241.40021 | 2092233.42701 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | 9 | 8 | 4 | 64 | 40 | |||
| 25077 | 178166 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 21 | : | Tree | Private 2 | 5 | Width 0ft | 5992891.51235 | 2087851.51661 | 37.7124346884767 | -122.466422861421 | (37.7124346884767, -122.466422861421) | 9 | 8 | 4 | 64 | 24 | |||
| 27670 | 178138 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20 Brotherhood Way | 9 | : | Tree | Private 2 | 7 | Width 0ft | 5992224.93754 | 2087880.30275 | 37.7124752425212 | -122.468728820297 | (37.7124752425212, -122.468728820297) | 9 | 8 | 4 | 64 | 24 | |||
| 27896 | 211024 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Junipero Serra Blvd | 94 | : | Tree | Private 2 | 6 | Width 0ft | 5991236.61569 | 2092101.43513 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | 9 | 8 | 4 | 64 | 40 | |||
| 30409 | 185563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984887.6667 | 2099768.5458 | 37.7446906142612 | -122.494964334306 | (37.7446906142612, -122.494964334306) | 1 | 8 | 3 | 29491 | 35 | |||
| 30677 | 178169 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 24 | : | Tree | Private 2 | 6 | Width 0ft | 5992786.91057 | 2087851.54482 | 37.7124287295635 | -122.466784396099 | (37.7124287295635, -122.466784396099) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 42301 | 87834 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 44422 | 94231 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | |||
| 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 | |||
| 53868 | 91504 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 62197 | 94233 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );