Street_Tree_List

Data source: data.sfgov.org

756 rows where qCaretaker = 2 and qSpecies = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PermitNotes

qCaretaker ✖

  • DPW · 756 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3 3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
437 437 20292 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
455 455 234501 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 2423 Market St 2 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
556 556 20399 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 44 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
1272 1272 251489 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 31 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1273 1273 251481 Property Tree 7 Pinus radiata :: Monterey Pine 3 32 Peralta Ave 1 Back Yard : Yard 13 Tree 1 DPW 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1282 1282 251482 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 1 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 1283 251493 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 35 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 1286 251492 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 34 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 1288 251487 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 29 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 1290 251486 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 28 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 1295 251491 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 33 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 1298 251490 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 32 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1299 1299 251494 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 36 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1316 1316 251488 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 30 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1322 1322 251483 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 8 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1332 1332 251484 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 7 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1338 1338 251485 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 900 Bosworth St 6 Front Yard : Yard 7 Tree 1 DPW 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1347 1347 251504 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 620x Noriega St 1 Median : Cutout 11 Tree 1 DPW 2       3x3   5992030.0 2103590.0 37.7555988620986 -122.470546036282 (37.7555988620986, -122.470546036282)
1547 1547 251582 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 691x Ulloa St 1 Back Yard : Cutout 16 Tree 1 DPW 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
1841 1841 20401 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 46 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
2042 2042 20405 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 50 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60            
2100 2100 178279 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Brotherhood Way 6 Front Yard : Yard 7 Tree 1 DPW 2     4 Width 0ft   5987917.15522 2088760.91322 37.714643374877895 -122.48368218070499 (37.7146433748779, -122.483682180705)
2268 2268 4983 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 5300 Diamond Heights Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/10/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001475.6363 2098933.58975 37.7433551224547 -122.43754668724199 (37.7433551224547, -122.437546687242)
2700 2700 20053 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY53 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 30            
3147 3147 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1290 Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3319 3319 4982 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 5300 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/31/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001462.73007 2098944.10019 37.743383247851604 -122.437592066128 (37.7433832478516, -122.437592066128)
3537 3537 102838 Undocumented 2 Pinus radiata :: Monterey Pine 3 1101X Portola Dr 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
4187 4187 20426 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
4260 4260 20045 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY52 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10            
4482 4482 20388 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
4528 4528 19968 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY43 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15            
5104 5104 253785 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 1675X 15th Ave 1 Median : Cutout 11 Tree 1 DPW 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5106 5106 253787 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 1675X 15th Ave 3 Median : Cutout 11 Tree 1 DPW 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5282 5282 20344 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 30 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 40            
5456 5456 20311 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50X Sunset Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
6219 6219 20290 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6407 6407 20308 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50X Sunset Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
6784 6784 20408 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 53 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
7028 7028 20295 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60            
7080 7080 20425 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
7092 7092 19853 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY29 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
7096 7096 20070 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY55 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
7176 7176 19977 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY45 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 30ST            
7292 7292 20433 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 485X Sunset Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30            
7424 7424 20416 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
7658 7658 20289 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
8078 8078 20329 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
8485 8485 20457 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Sunset Blvd 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
8592 8592 121500 Private 5 Pinus radiata :: Monterey Pine 3 251X Pennsylvania Ave 1 Back Yard : Yard 13 Tree 1 DPW 2                    
9506 9506 20420 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
9521 9521 20394 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 39 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
9600 9600 20367 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
9843 9843 20458 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Sunset Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
9855 9855 20400 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 45 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
9890 9890 3755 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 1050 Carolina St 1 Median : Cutout 11 Tree 1 DPW 2     12 18   6012450.5971046 2103074.0676917997 37.7553418567665 -122.39988853682199 (37.7553418567665, -122.399888536822)
9909 9909 173722 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 928 Carolina St 1 Median : Cutout 11 Tree 1 DPW 2     17 3x3   6012423.0 2103596.0 37.7567734300957 -122.400020627969 (37.7567734300957, -122.400020627969)
10214 10214 173907 Undocumented 2 Pinus radiata :: Monterey Pine 3 2200 Jerrold Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2           6012443.0 2099218.0 37.7447535037256 -122.399644080592 (37.7447535037256, -122.399644080592)
10388 10388 2288 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 3 Median : Cutout 11 Tree 1 DPW 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989397.47374 2088680.9253 37.714509804868605 -122.47855980688699 (37.7145098048686, -122.478559806887)
10567 10567 20323 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
10721 10721 2286 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 1 Median : Cutout 11 Tree 1 DPW 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989102.32398 2088689.12288 37.714515172905294 -122.4795805509 (37.7145151729053, -122.4795805509)
10850 10850 20451 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
10974 10974 20418 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
11124 11124 20380 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
11126 11126 2292 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 7 Median : Cutout 11 Tree 1 DPW 2     45 14M   5989842.77121 2088680.7511900002 37.7145351702246 -122.477020683771 (37.7145351702246, -122.477020683771)
11130 11130 20306 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
11192 11192 24264 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 350X Winding Way 2 Median : Cutout 11 Tree 1 DPW 2     24 8   6001155.71614 2086583.0952599999 37.709425288929296 -122.437768517615 (37.7094252889293, -122.437768517615)
11214 11214 20374 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
11595 11595 20431 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 485X Sunset Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 30            
11659 11659 106061 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 12X Canyon Dr 1 Median : Yard 3 Tree 1 DPW 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
11765 11765 20396 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 41 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
12513 12513 2291 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 6 Median : Cutout 11 Tree 1 DPW 2     24 14M   5989707.10535 2088681.30853 37.714528829127495 -122.477489635265 (37.7145288291275, -122.477489635265)
12711 12711 19749 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY15 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 10ST            
12855 12855 20286 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
12984 12984 2293 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 8 Median : Cutout 11 Tree 1 DPW 2     30 14M   5990043.7756199995 2088644.1713900003 37.71444639007029 -122.476323268498 (37.7144463900703, -122.476323268498)
13003 13003 24273 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 350X Winding Way 11 Median : Cutout 11 Tree 1 DPW 2     12 8   6000864.27338 2086762.8945799998 37.7099024017335 -122.43878866537399 (37.7099024017335, -122.438788665374)
13180 13180 20069 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY55 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 40ST            
13202 13202 20284 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
13213 13213 2294 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 800X Brotherhood Way 9 Median : Cutout 11 Tree 1 DPW 2     45 14M   5990137.079530001 2088614.4864299998 37.714370293032204 -122.475998609661 (37.7143702930322, -122.475998609661)
13357 13357 20454 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Sunset Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
13388 13388 20313 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
13426 13426 20293 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
13476 13476 20287 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
13681 13681 19775 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY18 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 50ST            
13746 13746 20338 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 40            
13748 13748 20343 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 29 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 40            
14111 14111 20421 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
14252 14252 20285 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
14683 14683 20337 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 24 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 40            
14835 14835 20387 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 33 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
14905 14905 20283 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
15072 15072 20052 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 30            
15202 15202 20339 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 101X Sunset Blvd 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 40            
15238 15238 20432 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 485X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 30            
15347 15347 20288 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
15632 15632 20427 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 453X Sunset Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
16056 16056 20402 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 47 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
16063 16063 20307 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
16202 16202 20435 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 485X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 30            
16297 16297 19969 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 STAIRWAY43 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 467.02ms · Data source: data.sfgov.org