Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47543 | 47543 | 201520 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6019241.773440001 | 2094383.32833 | 37.7318550858427 | -122.37579982552 | (37.7318550858427, -122.37579982552) | |||
| 163764 | 163764 | 201519 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6019223.74724 | 2094361.07733 | 37.7317929966527 | -122.375860604396 | (37.7317929966527, -122.375860604396) | |||
| 27606 | 27606 | 201518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 501 Griffith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6019207.673780001 | 2094338.78719 | 37.7317309074526 | -122.37591462936199 | (37.7317309074526, -122.375914629362) | |||
| 176927 | 176927 | 40009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.4041900001 | 37.732588803110204 | -122.377001897143 | (37.7325888031102, -122.377001897143) | |
| 152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
| 153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
| 132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
| 170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
| 181845 | 181845 | 201407 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 201 Harbor Rd | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6018140.985830001 | 2094924.5554099998 | 37.733280536449705 | -122.379643105252 | (37.7332805364497, -122.379643105252) | |||
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 71980 | 71980 | 196271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Cashmere St | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017110.310380001 | 2095865.5402400002 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | ||||
| 43128 | 43128 | 196270 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | ||||
| 29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
| 28003 | 28003 | 60357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | |
| 23318 | 23318 | 1917 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6016599.627230001 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | |||
| 46118 | 46118 | 38580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1375 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40540 | 6016458.6044 | 2093690.7438 | 37.729799797257 | -122.385373666801 | (37.729799797257, -122.385373666801) | |
| 50238 | 50238 | 116394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1351 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6016395.7433 | 2093382.8838 | 37.7289509966751 | -122.38556953980199 | (37.7289509966751, -122.385569539802) | |||
| 183509 | 183509 | 88051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1351 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51061 | 6016378.6669 | 2093395.5533 | 37.728984839756606 | -122.38562945735701 | (37.7289848397566, -122.385629457357) | |
| 149566 | 149566 | 87175 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1414 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50143 | 6016206.1979 | 2094998.2533 | 37.7333759901055 | -122.386337396865 | (37.7333759901055, -122.386337396865) | |
| 16482 | 16482 | 11411 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1482 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1992 12:00:00 AM | 6 | 3X4 | 6016167.7351400005 | 2096777.3502099998 | 37.738258902726 | -122.38659438804599 | (37.738258902726, -122.386594388046) | ||
| 16028 | 16028 | 11414 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1486 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016137.01095 | 2096800.6040700001 | 37.738321052161005 | -122.386702239228 | (37.738321052161, -122.386702239228) | |||
| 15803 | 15803 | 11415 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1486 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016124.41895 | 2096811.6938599998 | 37.7383508053301 | -122.386746549719 | (37.7383508053301, -122.386746549719) | |||
| 52400 | 52400 | 199862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1455 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016004.4926 | 2094023.6514 | 37.73068876117671 | -122.38696680587499 | (37.7306887611767, -122.386966805875) | |||
| 76090 | 76090 | 84687 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50141 | 6016000.88112 | 2096896.45557 | 37.738576703346205 | -122.387179597554 | (37.7385767033462, -122.387179597554) | |
| 173265 | 173265 | 196276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.738602740517294 | -122.38722376507499 | (37.7386027405173, -122.387223765075) | |||
| 131227 | 131227 | 199694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.727248236967704 | -122.38718652280701 | (37.7272482369677, -122.387186522807) | |||
| 16894 | 16894 | 26124 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.732840515342104 | -122.387408617446 | (37.7328405153421, -122.387408617446) | |||
| 151462 | 151462 | 38551 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1843 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | Permit Number 40519 | 6015881.5256 | 2093201.6545 | 37.728424911733896 | -122.387334607185 | (37.7284249117339, -122.387334607185) | |
| 176269 | 176269 | 38550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1843 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 4 | Permit Number 40519 | 6015868.3053 | 2093186.7815 | 37.728383341251394 | -122.38737927372298 | (37.7283833412514, -122.387379273723) | |
| 50115 | 50115 | 46630 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1494 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 4 | Permit Number 44751 | 6015833.2108 | 2095276.4238 | 37.7341191373642 | -122.387646329853 | (37.7341191373642, -122.387646329853) | |
| 182120 | 182120 | 200751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1419 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015822.8195 | 2094514.1504 | 37.7320255121303 | -122.387629091574 | (37.7320255121303, -122.387629091574) | |||
| 181173 | 181173 | 60368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | |
| 54947 | 54947 | 38600 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1473 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40551 | 6015747.1184 | 2093869.8344 | 37.7302521558979 | -122.38784586741801 | (37.7302521558979, -122.387845867418) | |
| 3644 | 3644 | 196082 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015721.57305 | 2103923.0720900004 | 37.7578548576382 | -122.388635680008 | (37.7578548576382, -122.388635680008) | |||
| 74643 | 74643 | 88044 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1527 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015719.2528800005 | 2096684.2880400002 | 37.737978534576605 | -122.388138539286 | (37.7379785345766, -122.388138539286) | |
| 50322 | 50322 | 88043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1527 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015705.98557 | 2096695.57507 | 37.7380087913713 | -122.38818519881 | (37.7380087913713, -122.38818519881) | |
| 77246 | 77246 | 60388 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1454 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 1 | Permit Number 19968 | 6015694.2103 | 2094682.8814 | 37.7324816889757 | -122.388085495957 | (37.7324816889757, -122.388085495957) | |
| 78092 | 78092 | 81703 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99712 | 99712 | 81708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99872 | 99872 | 81707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 106020 | 106020 | 81706 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 107902 | 107902 | 81705 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 108129 | 108129 | 81709 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 120717 | 120717 | 81704 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 139651 | 139651 | 81702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 52252 | 52252 | 88047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015649.6033 | 2096737.02814 | 37.7381194889247 | -122.388383034362 | (37.7381194889247, -122.388383034362) | |
| 55696 | 55696 | 196277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015638.97442 | 2096745.3057 | 37.738141628436296 | -122.38842036162501 | (37.7381416284363, -122.388420361625) | |||
| 31178 | 31178 | 88045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015625.12405 | 2096754.45465 | 37.7381659820759 | -122.388468888121 | (37.7381659820759, -122.388468888121) | |
| 49018 | 49018 | 196083 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015520.92899 | 2104914.9427 | 37.7605672003357 | -122.38939886178001 | (37.7605672003357, -122.38939886178) | |||
| 178277 | 178277 | 196084 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015520.282430001 | 2104924.05351 | 37.7605921808173 | -122.38940173421001 | (37.7605921808173, -122.38940173421) | |||
| 23751 | 23751 | 196085 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015519.48704 | 2104939.50859 | 37.760634573050794 | -122.389405564436 | (37.7606345730508, -122.389405564436) | |||
| 61240 | 61240 | 196086 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015519.14513 | 2104949.99214 | 37.760663339672 | -122.389407479081 | (37.760663339672, -122.389407479081) | |||
| 177298 | 177298 | 196087 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015517.7516 | 2104963.25372 | 37.7606996758621 | -122.38941322484501 | (37.7606996758621, -122.389413224845) | |||
| 72090 | 72090 | 196088 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015515.50483 | 2105016.50834 | 37.7608457770442 | -122.389424714573 | (37.7608457770442, -122.389424714573) | |||
| 57620 | 57620 | 196089 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015514.72199 | 2105046.29907 | 37.7609275325861 | -122.38942950257099 | (37.7609275325861, -122.389429502571) | |||
| 151306 | 151306 | 81701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 851 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 4 | Permit Number 768903 | 6015512.02282 | 2105063.44662 | 37.760974466422795 | -122.389440035426 | (37.7609744664228, -122.389440035426) | |
| 162884 | 162884 | 81682 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 851 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | Permit Number 768903 | 6015510.18333 | 2105095.74005 | 37.7610630352539 | -122.389448652757 | (37.7610630352539, -122.389448652757) | |
| 56624 | 56624 | 200791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1582 McKinnon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6015463.9227 | 2095899.7229 | 37.735810128216706 | -122.388966588384 | (37.7358101282167, -122.388966588384) | |||
| 30651 | 30651 | 196090 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015457.19385 | 2104954.19153 | 37.7606714353517 | -122.38962203573799 | (37.7606714353517, -122.389622035738) | |||
| 130457 | 130457 | 80599 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015456.308730001 | 2104984.78613 | 37.760755392471104 | -122.389627233831 | (37.7607553924711, -122.389627233831) | ||
| 151214 | 151214 | 79912 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015455.9807 | 2104968.54211 | 37.7607107716933 | -122.389627233809 | (37.7607107716933, -122.389627233809) | ||
| 149393 | 149393 | 80600 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015454.07391 | 2105001.72353 | 37.7608017750127 | -122.389636146116 | (37.7608017750127, -122.389636146116) | ||
| 183530 | 183530 | 80601 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015453.52186 | 2105016.91626 | 37.760843460373394 | -122.38963911655 | (37.7608434603734, -122.38963911655) | ||
| 32322 | 32322 | 80604 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.956 | 2105074.08431 | 37.761000400173295 | -122.38964506649201 | (37.7610004001733, -122.389645066492) | ||
| 55429 | 55429 | 80602 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.48136 | 2105039.81643 | 37.760906281622894 | -122.389644314657 | (37.7609062816229, -122.389644314657) | ||
| 101824 | 101824 | 80603 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6015452.3757 | 2105055.8553299997 | 37.7609503151357 | -122.389645800319 | (37.7609503151357, -122.389645800319) | ||
| 52772 | 52772 | 196194 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 87 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015403.39344 | 2112238.08548 | 37.780668423140895 | -122.39031702730301 | (37.7806684231409, -122.390317027303) | |||
| 31066 | 31066 | 196079 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015395.01764 | 2102273.41777 | 37.753307154219996 | -122.389649840082 | (37.75330715422, -122.389649840082) | ||||
| 153540 | 153540 | 196078 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015385.56179 | 2102265.48112 | 37.7532848375261 | -122.389681986358 | (37.7532848375261, -122.389681986358) | ||||
| 56155 | 56155 | 196081 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015382.92285 | 2102459.87565 | 37.7538184574574 | -122.389704688841 | (37.7538184574574, -122.389704688841) | ||||
| 58156 | 58156 | 196080 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015379.264690001 | 2102450.5128 | 37.7537925462017 | -122.389716685804 | (37.7537925462017, -122.389716685804) | ||||
| 183390 | 183390 | 49810 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 820 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015372.07913 | 2103953.6570599996 | 37.7579194622409 | -122.389846522708 | (37.7579194622409, -122.389846522708) | |
| 186939 | 186939 | 49811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 820 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015361.637130001 | 2103953.4257900002 | 37.7579182481496 | -122.389882619693 | (37.7579182481496, -122.389882619693) | |
| 185757 | 185757 | 200053 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1555 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015307.2832 | 2094192.9021 | 37.7311148594787 | -122.38938900173001 | (37.7311148594787, -122.38938900173) | |||
| 44979 | 44979 | 200782 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015278.1538 | 2096038.7748 | 37.7361816375316 | -122.389618578423 | (37.7361816375316, -122.389618578423) | |||
| 79959 | 79959 | 42068 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
| 30580 | 30580 | 199673 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1478 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015261.6654 | 2093256.0880000002 | 37.7285400265271 | -122.389481312404 | (37.7285400265271, -122.389481312404) | |||
| 183702 | 183702 | 200046 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1567 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015241.3298 | 2094241.2680000002 | 37.731244005670206 | -122.389620392742 | (37.7312440056702, -122.389620392742) | |||
| 92375 | 92375 | 38577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1535 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40537 | 6015234.7344 | 2094950.5426 | 37.733191164968 | -122.389692714774 | (37.733191164968, -122.389692714774) | |
| 43287 | 43287 | 196091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6015230.48964 | 2104060.4129 | 37.7582047379774 | -122.390343661653 | (37.7582047379774, -122.390343661653) | |||
| 154710 | 154710 | 57075 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 10 | Permit Number 14342 | 6015229.87754 | 2104071.31623 | 37.758234642233894 | -122.39034654036999 | (37.7582346422339, -122.39034654037) | ||
| 116983 | 116983 | 38583 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40543 | 6015225.14493834 | 2094611.56119995 | 37.7322598587405 | -122.38970220057199 | (37.7322598587405, -122.389702200572) | ||
| 124161 | 124161 | 38588 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40543 | 6015225.14493834 | 2094611.56119995 | 37.7322598587405 | -122.38970220057199 | (37.7322598587405, -122.389702200572) | ||
| 13393 | 13393 | 39264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015215.52427 | 2113624.4278599997 | 37.7844645829043 | -122.39106388910601 | (37.7844645829043, -122.391063889106) |
| 43008 | 43008 | 38589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1606 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40544 | 6015214.8687 | 2094687.4678 | 37.7324677131079 | -122.389743028049 | (37.7324677131079, -122.389743028049) | |
| 156050 | 156050 | 200044 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1600 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015203.4065 | 2094586.9741 | 37.732191142068 | -122.389775639203 | (37.732191142068, -122.389775639203) | |||
| 15282 | 15282 | 39266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015200.60575 | 2113640.87265 | 37.784508908704 | -122.39111665233101 | (37.784508908704, -122.391116652331) |
| 39554 | 39554 | 38584 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015197.8625 | 2094625.9840000002 | 37.7322979479453 | -122.389797530007 | (37.7322979479453, -122.389797530007) | |
| 155599 | 155599 | 200045 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1600 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015192.9639 | 2094571.5849 | 37.732148307342 | -122.38981066738899 | (37.732148307342, -122.389810667389) | |||
| 16626 | 16626 | 39265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015189.334319999 | 2113651.1602 | 37.78453653049 | -122.391156367288 | (37.78453653049, -122.391156367288) |
| 73070 | 73070 | 38585 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 3 | Permit Number 40543 | 6015181.5104 | 2094639.0656 | 37.7323329605685 | -122.38985497686701 | (37.7323329605685, -122.389854976867) | |
| 53269 | 53269 | 38586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 5 | Permit Number 40543 | 6015170.391 | 2094645.6065 | 37.7323503039144 | -122.389893876253 | (37.7323503039144, -122.389893876253) | |
| 164492 | 164492 | 38587 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015156.0012 | 2094654.7636 | 37.7323746494327 | -122.38994426497 | (37.7323746494327, -122.38994426497) | |
| 33706 | 33706 | 200024 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1624 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015148.4453 | 2094513.8756 | 37.73198738037679 | -122.389960549589 | (37.7319873803768, -122.389960549589) | |||
| 74408 | 74408 | 83942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6015103.3012 | 2090231.7832 | 37.72022710350421 | -122.389817632552 | (37.7202271035042, -122.389817632552) | ||
| 66873 | 66873 | 196280 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.39093196394501 | (37.7530717153135, -122.390931963945) | ||||
| 130300 | 130300 | 196281 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 12 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015018.372359999 | 2102200.19302 | 37.7530852024401 | -122.39094725063102 | (37.7530852024401, -122.390947250631) | ||||
| 137606 | 137606 | 196282 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 13 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015015.25562 | 2102205.64875 | 37.75310000977571 | -122.39095841029499 | (37.7531000097757, -122.390958410295) | ||||
| 33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
| 132022 | 132022 | 196279 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 6 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.39105995634701 | (37.7529045205317, -122.391059956347) |
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");