trees
2,306 rows where qSpecies_id = 15 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12546 | 111544 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 22 | Front Yard : Yard | Tree | DPW 1 | 10 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
12739 | 30076 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
12894 | 20288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12954 | 20695 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
13192 | 20368 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
13246 | 216499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Bosworth St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6001469.53693 | 2095587.89447 | 37.7341682770342 | -122.437328259898 | (37.7341682770342, -122.437328259898) | 9 | 7 | 5 | 63 | 40 | |||
13472 | 259334 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 179X Midcrest Way | 1 | Front Yard : Yard | Tree | DPW 1 | 30x30 | 5998457 | 2101296 | 37.7496696385244 | -122.448154381331 | (37.7496696385244, -122.448154381331) | 1 | 5 | 4 | 63 | 38 | ||||
13588 | 20425 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13664 | 21451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
13721 | 261493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
14170 | 20388 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
14228 | 211132 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 39 | Median : Yard | Tree | DPW 1 | 13 | Width 8ft | 5994073.5471 | 2101557.93366 | 37.750137280527 | -122.463331413139 | (37.750137280527, -122.463331413139) | 1 | 8 | 4 | 29491 | 40 | |||
14265 | 20575 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
14280 | 20070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY55 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
14435 | 20307 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
14470 | 261472 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
14843 | 19968 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
15008 | 20387 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
15020 | 20401 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15388 | 20295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
16107 | 262406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2827 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010428 | 2100696 | 37.7486992403688 | -122.406715738075 | (37.7486992403688, -122.406715738075) | 2 | 4 | 7 | 28859 | 2 | ||||
16184 | 19977 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY45 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
16290 | 20286 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
16411 | 20053 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
17040 | 21086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
17047 | 20343 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
17057 | 20306 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
17132 | 20690 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
18328 | 20339 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
18358 | 20374 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
18633 | 20454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
18799 | 20738 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
18945 | 20432 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 30 | |||||||||||||
19039 | 20396 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
19072 | 20380 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | |||||||||||||
19504 | 21311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
19737 | 20658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
20123 | 20914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1901X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
20906 | 211157 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Marietta Dr | 37 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999448.78231 | 2097518.60545 | 37.7393544676471 | -122.444453333051 | (37.7393544676471, -122.444453333051) | 9 | 7 | 4 | 59 | 40 | |||
21288 | 178260 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 74 | Width 0ft | 6009513.56677 | 2090039.51327 | 37.7193876062417 | -122.409126009759 | (37.7193876062417, -122.409126009759) | 9 | 3 | 8 | 309 | 18 | |||
21571 | 4976 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5200X Diamond Heights Blvd | 12 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000956.30514 | 2099403.67096 | 37.7446163137028 | -122.439376085452 | (37.7446163137028, -122.439376085452) | 2 | 7 | 5 | 63 | 7 | |||
21587 | 30086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
21774 | 2295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
22044 | 211228 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Santa Rita Ave | 2 | Median : Cutout | Tree | DPW 1 | 29 | Width 5ft | 5993736.50013 | 2100633.35574 | 37.7475792012252 | -122.464429809989 | (37.7475792012252, -122.464429809989) | 1 | 8 | 4 | 29491 | 40 | |||
22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
22742 | 112442 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 36 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
23475 | 211127 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335X Pacheco St | 33 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 5994124.86854 | 2101482.06932 | 37.7499319329208 | -122.463148437947 | (37.7499319329208, -122.463148437947) | 1 | 8 | 4 | 29491 | 40 | |||
23614 | 173920 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160X 09th Ave | 8 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
23769 | 20764 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
24560 | 21304 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
24656 | 211230 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Santa Rita Ave | 4 | Median : Cutout | Tree | DPW 1 | 34 | Width 5ft | 5993731.93938 | 2100593.11713 | 37.7474684533162 | -122.464442659515 | (37.7474684533162, -122.464442659515) | 1 | 8 | 4 | 29491 | 40 | |||
24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
25153 | 211100 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 198x San Anselmo Ave | 4 | Median : Yard | Tree | DPW 1 | 41 | 5993653.9743 | 2096326.24073 | 37.7357481880204 | -122.464402505688 | (37.7357481880204, -122.464402505688) | 1 | 8 | 4 | 59 | 40 | ||||
25236 | 211122 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 27 | Median : Yard | Tree | DPW 1 | 26 | Width 8ft | 5994167.1459 | 2101393.52573 | 37.749691250071 | -122.462995818511 | (37.749691250071, -122.462995818511) | 1 | 8 | 4 | 29491 | 40 | |||
25252 | 20755 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
25280 | 111534 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 12 | Front Yard : Yard | Tree | DPW 1 | 30 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
25879 | 20673 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
25947 | 20565 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
26419 | 256644 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Miraloma Dr | 3 | Side Yard : Cutout | Tree | DPW 1 | 10x10 | 5994995 | 2097925 | 37.7402151966004 | -122.459881864698 | (37.7402151966004, -122.459881864698) | 9 | 8 | 4 | 59 | 40 | ||||
26583 | 108044 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard | Tree | DPW 1 | 99 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
26812 | 211161 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Idora Ave | 17 | Median : Yard | Tree | DPW 1 | 41 | Width 9ft | 5995684.47383 | 2099331.08009 | 37.7441155729727 | -122.457599666806 | (37.7441155729727, -122.457599666806) | 1 | 8 | 4 | 59 | 40 | |||
27298 | 20941 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
27623 | 20595 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984800.4502923 | 2105635.4093669 | 37.7607942988513 | -122.495698574627 | (37.7607942988513, -122.495698574627) | 1 | 8 | 3 | 56 | 35 | |||
27645 | 251483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 8 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
27733 | 20698 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1592X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | 1 | 8 | 3 | 56 | 35 | |||
27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
28191 | 4983 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001475.6363 | 2098933.58975 | 37.7433551224547 | -122.437546687242 | (37.7433551224547, -122.437546687242) | 2 | 7 | 5 | 63 | 7 | |
28201 | 178257 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 38 | Width 0ft | 6010033.34166 | 2090220.70583 | 37.7199142285308 | -122.407342099256 | (37.7199142285308, -122.407342099256) | 10 | 3 | 8 | 309 | 18 | |||
28407 | 194476 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 43 | Median : Yard | Tree | DPW 1 | 22 | 6012491.75598 | 2103075.93483 | 37.755349278054 | -122.399746327228 | (37.755349278054, -122.399746327228) | 10 | 3 | 8 | 28856 | 29 | ||||
28834 | 251489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 31 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
29143 | 21458 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
29182 | 30079 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
29224 | 116662 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
29301 | 121490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 24 | 6011163.12299 | 2106299.7163 | 37.7641269067524 | -122.404568089162 | (37.7641269067524, -122.404568089162) | 8 | 3 | 8 | 28856 | 29 | ||||
29719 | 111573 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x SUNSET BLVD OFF RAMP | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 5984955 | 2095624 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | 1 | 8 | 4 | 64 | 35 | ||||
30323 | 122488 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
30688 | 21421 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2692X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
30913 | 20970 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2002X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
31542 | 21344 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2592X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
31743 | 20763 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
31937 | 211104 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2187x 09th Ave | 8 | Median : Yard | Tree | DPW 1 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) | 1 | 8 | 4 | 29491 | 40 | ||||
32070 | 21450 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2701X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
32242 | 173916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160X 09th Ave | 4 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
32606 | 20583 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
33017 | 4997 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300X Diamond Heights Blvd | 14 | Median : Cutout | Tree | DPW 1 | 24 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | ||||
33452 | 2296 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 50 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
33709 | 105762 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400X CASTRO ST | 13 | Median : Yard | Tree | DPW 1 | 20 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | ||||
33971 | 20573 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
34054 | 178267 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 350x Winding Way | 7 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6001101.51532 | 2086589.41989 | 37.7094395728456 | -122.437956296952 | (37.7094395728456, -122.437956296952) | 9 | 7 | 6 | 28861 | 5 | |||
34071 | 211245 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 15x San Marcos Ave | 25 | Median : Cutout | Tree | DPW 1 | 24 | Width 5ft | 5993240.72195 | 2100276.68476 | 37.7465712824474 | -122.466118252063 | (37.7465712824474, -122.466118252063) | 1 | 8 | 4 | 29491 | 40 | |||
34141 | 211103 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2187x 09th Ave | 7 | Median : Yard | Tree | DPW 1 | 42 | 5993592.96046 | 2100932.97127 | 37.7483935940092 | -122.464947913926 | (37.7483935940092, -122.464947913926) | 1 | 8 | 4 | 29491 | 40 | ||||
34286 | 20805 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1792X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
34393 | 211111 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 5 | Median : Yard | Tree | DPW 1 | 21 | Width 8ft | 5994189.10111 | 2101103.38332 | 37.7488958572711 | -122.462898850009 | (37.7488958572711, -122.462898850009) | 1 | 8 | 4 | 29491 | 40 | |||
34420 | 211112 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 6 | Median : Yard | Tree | DPW 1 | 44 | Width 8ft | 5994184.95875 | 2101126.78073 | 37.7489598620291 | -122.462914871445 | (37.7489598620291, -122.462914871445) | 1 | 8 | 4 | 29491 | 40 |
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) );