Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4579 | 4579 | 129649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009816.83805 | 2121725.3616299997 | 37.806406712567295 | -122.41031374259501 | (37.8064067125673, -122.410313742595) | |||
| 11692 | 11692 | 77644 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | |
| 19637 | 19637 | 100232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983809.619390001 | 2110917.38856 | 37.775239033091104 | -122.499515726535 | (37.7752390330911, -122.499515726535) | |||
| 23320 | 23320 | 6751 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.5380000002 | 37.738173145164104 | -122.38185469014499 | (37.7381731451641, -122.381854690145) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 24118 | 24118 | 250112 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006087.8268 | 2115423.32638 | 37.7888931792348 | -122.42277052116002 | (37.7888931792348, -122.42277052116) | |||
| 27202 | 27202 | 191492 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008677.6339 | 2110340.84375 | 37.7750836791036 | -122.413450522147 | (37.7750836791036, -122.413450522147) | |||
| 28947 | 28947 | 248524 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998860.1966 | 2107787.9248 | 37.767517892733295 | -122.44722728729201 | (37.7675178927333, -122.447227287292) | |||
| 29382 | 29382 | 183930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988704.6498 | 2101009.2638 | 37.748320004874 | -122.48185697108299 | (37.748320004874, -122.481856971083) | |||
| 30215 | 30215 | 116049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.761554468880206 | -122.403342277248 | (37.7615544688802, -122.403342277248) | ||
| 32113 | 32113 | 191442 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2250 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012056.709559999 | 2101893.12707 | 37.7520772845403 | -122.40116774801001 | (37.7520772845403, -122.40116774801) | |||
| 35051 | 35051 | 129602 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1699 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005553.17918 | 2118195.8648 | 37.796475692558204 | -122.42481765510901 | (37.7964756925582, -122.424817655109) | |||
| 35203 | 35203 | 96010 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767660 | 6009745.43326 | 2116416.2091099997 | 37.7918250833144 | -122.410185778057 | (37.7918250833144, -122.410185778057) |
| 37031 | 37031 | 227196 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 434 Banks St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008563.57852 | 2096642.27397 | 37.7374641106746 | -122.412876351788 | (37.7374641106746, -122.412876351788) | |||
| 37843 | 37843 | 249627 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.45176635913602 | (37.777145918089, -122.451766359136) | |||
| 38703 | 38703 | 191455 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014431.23151 | 2115982.96922 | 37.7908970414242 | -122.393942451705 | (37.7908970414242, -122.393942451705) | |||
| 39162 | 39162 | 207829 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999329.280119999 | 2093797.53913 | 37.7291304772829 | -122.44459914196301 | (37.7291304772829, -122.444599141963) | |||
| 41868 | 41868 | 227288 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 689 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002143.45873 | 2098830.19502 | 37.7431091713442 | -122.43523013797501 | (37.7431091713442, -122.435230137975) | ||||
| 42817 | 42817 | 113964 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 11 | 3x3 | 6011665.76024 | 2107233.19616 | 37.766718110767705 | -122.402895261101 | (37.7667181107677, -122.402895261101) | ||
| 42939 | 42939 | 227342 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008421.86118 | 2096747.11308 | 37.7377440201602 | -122.413373748818 | (37.7377440201602, -122.413373748818) | |||
| 44207 | 44207 | 98648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | ||
| 47662 | 47662 | 207856 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993273.296130001 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | |||
| 48436 | 48436 | 177044 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 87 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000253.62595 | 2089858.9653200002 | 37.7183687570946 | -122.44112115243999 | (37.7183687570946, -122.44112115244) | |||
| 49902 | 49902 | 177138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 567 Bowdoin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008881.29174 | 2093378.99217 | 37.7285216695165 | -122.411547373223 | (37.7285216695165, -122.411547373223) | |||
| 51763 | 51763 | 227423 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4611 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000635.58472 | 2104641.67508 | 37.758980351992705 | -122.44086074744 | (37.7589803519927, -122.44086074744) | |||
| 52138 | 52138 | 177088 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 300x Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6001504.621119999 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | |||
| 52193 | 52193 | 129657 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009762.6965 | 2121791.5732400003 | 37.8065854780119 | -122.410505788321 | (37.8065854780119, -122.410505788321) | |||
| 52389 | 52389 | 207960 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995744.16421 | 2100249.0413599997 | 37.7466394951101 | -122.457459672038 | (37.7466394951101, -122.457459672038) | |||
| 53296 | 53296 | 207964 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 25 Stanford Heights Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997817.68344 | 2095709.5147 | 37.7342939366213 | -122.44996257451099 | (37.7342939366213, -122.449962574511) | |||
| 55005 | 55005 | 227516 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006494.66605 | 2109620.24654 | 37.772982280939004 | -122.420950728601 | (37.772982280939, -122.420950728601) | |||
| 55814 | 55814 | 177063 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.44544943653601 | (37.7201371416945, -122.445449436536) | |||
| 61200 | 61200 | 207832 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999123.91286 | 2093462.3743099999 | 37.7281984720769 | -122.44528502248001 | (37.7281984720769, -122.44528502248) | ||||
| 61317 | 61317 | 227283 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4412 23rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6000531.63027 | 2102304.55034 | 37.7525572554152 | -122.441052598925 | (37.7525572554152, -122.441052598925) | |||
| 63024 | 63024 | 227364 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008046.81581 | 2101093.50284 | 37.7496571774348 | -122.41497800984502 | (37.7496571774348, -122.414978009845) | |||
| 68510 | 68510 | 245072 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000401.2404 | 2108998.8674 | 37.7709307712672 | -122.441983963405 | (37.7709307712672, -122.441983963405) | |||
| 68735 | 68735 | 177054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998957.42918 | 2090181.0336799999 | 37.719179165869996 | -122.44562469283001 | (37.71917916587, -122.44562469283) | |||
| 70419 | 70419 | 227286 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 691 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002107.89107 | 2098826.5345400004 | 37.743097100666 | -122.435352859445 | (37.743097100666, -122.435352859445) | ||||
| 74217 | 74217 | 227255 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6006055.55534 | 2096385.4098900002 | 37.736617720934504 | -122.421529541274 | (37.7366177209345, -122.421529541274) | |||
| 76685 | 76685 | 227309 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002319.695169999 | 2098302.33211 | 37.741669789339205 | -122.434583024505 | (37.7416697893392, -122.434583024505) | |||
| 83225 | 83225 | 20264 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | |||
| 84742 | 84742 | 121398 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4098x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002425.0 | 2104765.0 | 37.7594207214866 | -122.434680934086 | (37.7594207214866, -122.434680934086) | ||||
| 91968 | 91968 | 37256 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 92446 | 92446 | 20269 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 92729 | 92729 | 98679 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 93845 | 93845 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 273 Magellan Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 97306 | 97306 | 111021 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 98684 | 98684 | 9317 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | ||
| 101877 | 101877 | 102191 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 103928 | 103928 | 92843 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2009 12:00:00 AM | 3x3 | 6006883.0 | 2101475.0 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | |||
| 106555 | 106555 | 103605 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
| 107667 | 107667 | 92632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 108812 | 108812 | 7212 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 115141 | 115141 | 110189 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 130227 | 130227 | 114469 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009301.69448 | 2121635.8419 | 37.806132023649795 | -122.41209016533999 | (37.8061320236498, -122.41209016534) | |||
| 130983 | 130983 | 207922 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993570.7217 | 2095074.32308 | 37.732305933067 | -122.46459946350299 | (37.732305933067, -122.464599463503) | |||
| 131714 | 131714 | 140577 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1217 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003319.3616 | 2111705.1064 | 37.778527292754795 | -122.43208339724801 | (37.7785272927548, -122.432083397248) | |||
| 131942 | 131942 | 129597 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005573.05547 | 2117336.02058 | 37.7941159002879 | -122.424687680612 | (37.7941159002879, -122.424687680612) | |||
| 132779 | 132779 | 227268 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001722.7938 | 2099972.97988 | 37.7462230919366 | -122.436766469611 | (37.7462230919366, -122.436766469611) | |||
| 133343 | 133343 | 129626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2137 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006390.19971 | 2118075.3659099997 | 37.796192073372296 | -122.421912814324 | (37.7961920733723, -122.421912814324) | |||
| 139054 | 139054 | 20279 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | ||
| 143097 | 143097 | 89036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 144349 | 144349 | 20274 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 152084 | 152084 | 227444 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002287.98273 | 2104149.3571099997 | 37.757722534984495 | -122.43511077364599 | (37.7577225349845, -122.435110773646) | |||
| 155404 | 155404 | 122134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991116.74625 | 2115003.65081 | 37.78688480325761 | -122.4745372499 | (37.7868848032576, -122.4745372499) | ||||
| 157541 | 157541 | 120479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 5988612.47401 | 2114641.5086 | 37.785745047419 | -122.48317479571301 | (37.785745047419, -122.483174795713) | |||
| 157783 | 157783 | 227304 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002725.4323 | 2099066.84867 | 37.7437919986955 | -122.433234737486 | (37.7437919986955, -122.433234737486) | ||||
| 158698 | 158698 | 129667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009344.79815 | 2121669.41984 | 37.806226638614895 | -122.41194337170099 | (37.8062266386149, -122.411943371701) | |||
| 164201 | 164201 | 227174 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 146 Alma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997925.34727 | 2106207.55247 | 37.7631251303526 | -122.450346856639 | (37.7631251303526, -122.450346856639) | |||
| 164796 | 164796 | 226752 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 188 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004776.274730001 | 2109101.09065 | 37.7714597925537 | -122.426857876903 | (37.7714597925537, -122.426857876903) | |||
| 166541 | 166541 | 207900 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991529.51733 | 2097072.3432599998 | 37.737674106866 | -122.471801868461 | (37.737674106866, -122.471801868461) | |||
| 166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
| 172722 | 172722 | 227511 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 37 Brady St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006521.3754199995 | 2109731.86389 | 37.7732902609724 | -122.420866263385 | (37.7732902609724, -122.420866263385) | |||
| 176366 | 176366 | 200062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014902.219 | 2094116.2312 | 37.7308818705774 | -122.390784034613 | (37.7308818705774, -122.390784034613) | |||
| 176630 | 176630 | 227227 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3181 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007147.960390001 | 2103204.37763 | 37.7554026078658 | -122.418235932549 | (37.7554026078658, -122.418235932549) | |||
| 178340 | 178340 | 207946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992698.06615 | 2100499.1066400004 | 37.7471506733717 | -122.468010857342 | (37.7471506733717, -122.468010857342) | |||
| 178787 | 178787 | 207821 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998204.93693 | 2093811.9679400001 | 37.7291058736189 | -122.44848710990499 | (37.7291058736189, -122.448487109905) | |||
| 181058 | 181058 | 226689 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6011390.6750300005 | 2102355.0144 | 37.7533083467103 | -122.403503500497 | (37.7533083467103, -122.403503500497) | |||
| 182669 | 182669 | 227377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006820.372690001 | 2101479.14572 | 37.7506470711158 | -122.41924645667 | (37.7506470711158, -122.41924645667) | |||
| 183307 | 183307 | 129678 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) |
JSON shape: default, array, newline-delimited
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");