trees
6,714 rows where qSpecies_id = 7 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
60321 | 201520 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Griffith St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6019241.77344 | 2094383.32833 | 37.7318550858427 | -122.37579982552 | (37.7318550858427, -122.37579982552) | 10 | 3 | 8 | 58 | 1 | |||
95785 | 201519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Griffith St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6019223.74724 | 2094361.07733 | 37.7317929966527 | -122.375860604396 | (37.7317929966527, -122.375860604396) | 10 | 3 | 8 | 58 | 1 | |||
161880 | 201518 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Griffith St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6019207.67378 | 2094338.78719 | 37.7317309074526 | -122.375914629362 | (37.7317309074526, -122.375914629362) | 10 | 3 | 8 | 58 | 1 | |||
16650 | 40009 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.40419 | 37.7325888031102 | -122.377001897143 | (37.7325888031102, -122.377001897143) | 10 | 3 | 8 | 58 | 1 | |
190701 | 196275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.377627436781 | (37.729921505667, -122.377627436781) | 10 | 3 | 8 | 58 | 1 | |||
127642 | 196274 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | 10 | 3 | 8 | 58 | 1 | |||
13333 | 196273 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.7299348462003 | -122.377699306103 | (37.7299348462003, -122.377699306103) | 10 | 3 | 8 | 58 | 1 | |||
189427 | 196272 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6018667.18531 | 2093699.95339 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | 10 | 3 | 8 | 58 | 1 | |||
141784 | 201407 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 201 Harbor Rd | 2 | : | Tree | Private 2 | 4 | Width 4ft | 6018140.98583 | 2094924.55541 | 37.7332805364497 | -122.379643105252 | (37.7332805364497, -122.379643105252) | 10 | 3 | 8 | 58 | 1 | |||
77245 | 6391 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | 10 | 3 | 8 | 58 | 1 | ||
119531 | 196271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Cashmere St | 1 | : | Tree | Private 2 | 31 | 6017110.31038 | 2095865.54024 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | 10 | 3 | 8 | 58 | 1 | ||||
55214 | 196270 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 3 | Median : Yard | Tree | DPW 1 | 11 | 6016861.7614 | 2096200.30133 | 37.7367128395304 | -122.384154590289 | (37.7367128395304, -122.384154590289) | 10 | 3 | 8 | 58 | 1 | ||||
19870 | 196269 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50x Dedman Ct | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.384189093646 | (37.7366779736991, -122.384189093646) | 10 | 3 | 8 | 58 | 1 | ||||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
181918 | 1917 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6016599.62723 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | 10 | 3 | 8 | 58 | 1 | |||
127273 | 38580 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1375 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40540 | 6016458.6044 | 2093690.7438 | 37.729799797257 | -122.385373666801 | (37.729799797257, -122.385373666801) | 10 | 3 | 8 | 58 | 1 | |
119963 | 116394 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1351 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016395.7433 | 2093382.8838 | 37.7289509966751 | -122.385569539802 | (37.7289509966751, -122.385569539802) | 10 | 3 | 8 | 58 | 1 | |||
48744 | 88051 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1351 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51061 | 6016378.6669 | 2093395.5533 | 37.7289848397566 | -122.385629457357 | (37.7289848397566, -122.385629457357) | 10 | 3 | 8 | 58 | 1 | |
107798 | 87175 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1414 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50143 | 6016206.1979 | 2094998.2533 | 37.7333759901055 | -122.386337396865 | (37.7333759901055, -122.386337396865) | 10 | 3 | 8 | 58 | 1 | |
187280 | 11411 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1482 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/10/1992 12:00:00 AM | 6 | 3X4 | 6016167.73514 | 2096777.35021 | 37.738258902726 | -122.386594388046 | (37.738258902726, -122.386594388046) | 10 | 3 | 8 | 58 | 1 | ||
140251 | 11414 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1486 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016137.01095 | 2096800.60407 | 37.738321052161 | -122.386702239228 | (37.738321052161, -122.386702239228) | 10 | 3 | 8 | 58 | 1 | |||
191575 | 199862 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1455 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016004.4926 | 2094023.6514 | 37.7306887611767 | -122.386966805875 | (37.7306887611767, -122.386966805875) | 10 | 3 | 8 | 58 | 1 | |||
96950 | 84687 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1514 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50141 | 6016000.88112 | 2096896.45557 | 37.7385767033462 | -122.387179597554 | (37.7385767033462, -122.387179597554) | 10 | 3 | 8 | 58 | 1 | |
124505 | 199694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.7272482369677 | -122.387186522807 | (37.7272482369677, -122.387186522807) | 10 | 3 | 8 | 58 | 1 | |||
50728 | 196276 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.7386027405173 | -122.387223765075 | (37.7386027405173, -122.387223765075) | 10 | 3 | 8 | 58 | 1 | |||
11912 | 38551 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1843 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40519 | 6015881.5256 | 2093201.6545 | 37.7284249117339 | -122.387334607185 | (37.7284249117339, -122.387334607185) | 10 | 3 | 8 | 58 | 1 | |
15961 | 38550 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1843 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 4 | Permit Number 40519 | 6015868.3053 | 2093186.7815 | 37.7283833412514 | -122.387379273723 | (37.7283833412514, -122.387379273723) | 10 | 3 | 8 | 58 | 1 | |
193035 | 26124 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.7328405153421 | -122.387408617446 | (37.7328405153421, -122.387408617446) | 10 | 3 | 8 | 58 | 1 | |||
159779 | 200751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1419 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015822.8195 | 2094514.1504 | 37.7320255121303 | -122.387629091574 | (37.7320255121303, -122.387629091574) | 10 | 3 | 8 | 58 | 1 | |||
161257 | 46630 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1494 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 4 | Permit Number 44751 | 6015833.2108 | 2095276.4238 | 37.7341191373642 | -122.387646329853 | (37.7341191373642, -122.387646329853) | 10 | 3 | 8 | 58 | 1 | |
6039 | 60368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | 10 | 3 | 8 | 58 | 1 | |
111143 | 38600 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1473 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40551 | 6015747.1184 | 2093869.8344 | 37.7302521558979 | -122.387845867418 | (37.7302521558979, -122.387845867418) | 10 | 3 | 8 | 58 | 1 | |
12409 | 60388 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1454 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 1 | Permit Number 19968 | 6015694.2103 | 2094682.8814 | 37.7324816889757 | -122.388085495957 | (37.7324816889757, -122.388085495957) | 10 | 3 | 8 | 58 | 1 | |
188070 | 88044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1527 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015719.25288 | 2096684.28804 | 37.7379785345766 | -122.388138539286 | (37.7379785345766, -122.388138539286) | 10 | 3 | 8 | 58 | 1 | |
84260 | 88043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1527 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51056 | 6015705.98557 | 2096695.57507 | 37.7380087913713 | -122.38818519881 | (37.7380087913713, -122.38818519881) | 10 | 3 | 8 | 58 | 1 | |
126351 | 88047 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1547 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015649.6033 | 2096737.02814 | 37.7381194889247 | -122.388383034362 | (37.7381194889247, -122.388383034362) | 10 | 3 | 8 | 58 | 1 | |
50144 | 196277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015638.97442 | 2096745.3057 | 37.7381416284363 | -122.388420361625 | (37.7381416284363, -122.388420361625) | 10 | 3 | 8 | 58 | 1 | |||
80530 | 88045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1547 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015625.12405 | 2096754.45465 | 37.7381659820759 | -122.388468888121 | (37.7381659820759, -122.388468888121) | 10 | 3 | 8 | 58 | 1 | |
39617 | 196082 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015721.57305 | 2103923.07209 | 37.7578548576382 | -122.388635680008 | (37.7578548576382, -122.388635680008) | 10 | 3 | 8 | 28856 | 29 | |||
30048 | 81703 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
96209 | 81707 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
110110 | 81708 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
116918 | 81706 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
121847 | 81709 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
132299 | 81705 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
156589 | 81704 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
173350 | 81702 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 728 20th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | 10 | 3 | 8 | 28856 | 29 | ||
166188 | 200791 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1582 McKinnon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6015463.9227 | 2095899.7229 | 37.7358101282167 | -122.388966588384 | (37.7358101282167, -122.388966588384) | 10 | 3 | 8 | 58 | 1 | |||
54282 | 200053 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1555 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015307.2832 | 2094192.9021 | 37.7311148594787 | -122.38938900173 | (37.7311148594787, -122.38938900173) | 10 | 3 | 8 | 58 | 1 | |||
181939 | 196083 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015520.92899 | 2104914.9427 | 37.7605672003357 | -122.38939886178 | (37.7605672003357, -122.38939886178) | 10 | 3 | 8 | 28856 | 29 | |||
31100 | 196084 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015520.28243 | 2104924.05351 | 37.7605921808173 | -122.38940173421 | (37.7605921808173, -122.38940173421) | 10 | 3 | 8 | 28856 | 29 | |||
64161 | 196085 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015519.48704 | 2104939.50859 | 37.7606345730508 | -122.389405564436 | (37.7606345730508, -122.389405564436) | 10 | 3 | 8 | 28856 | 29 | |||
104671 | 196086 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015519.14513 | 2104949.99214 | 37.760663339672 | -122.389407479081 | (37.760663339672, -122.389407479081) | 10 | 3 | 8 | 28856 | 29 | |||
133014 | 196087 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015517.7516 | 2104963.25372 | 37.7606996758621 | -122.389413224845 | (37.7606996758621, -122.389413224845) | 10 | 3 | 8 | 28856 | 29 | |||
74014 | 196088 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015515.50483 | 2105016.50834 | 37.7608457770442 | -122.389424714573 | (37.7608457770442, -122.389424714573) | 10 | 3 | 8 | 28856 | 29 | |||
187513 | 196089 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 899 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015514.72199 | 2105046.29907 | 37.7609275325861 | -122.389429502571 | (37.7609275325861, -122.389429502571) | 10 | 3 | 8 | 28856 | 29 | |||
59276 | 81701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 851 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2012 12:00:00 AM | 4 | Permit Number 768903 | 6015512.02282 | 2105063.44662 | 37.7609744664228 | -122.389440035426 | (37.7609744664228, -122.389440035426) | 10 | 3 | 8 | 28856 | 29 | |
16449 | 81682 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 851 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2012 12:00:00 AM | 5 | Permit Number 768903 | 6015510.18333 | 2105095.74005 | 37.7610630352539 | -122.389448652757 | (37.7610630352539, -122.389448652757) | 10 | 3 | 8 | 28856 | 29 | |
136632 | 199673 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1478 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015261.6654 | 2093256.088 | 37.7285400265271 | -122.389481312404 | (37.7285400265271, -122.389481312404) | 10 | 3 | 8 | 58 | 1 | |||
122362 | 200782 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015278.1538 | 2096038.7748 | 37.7361816375316 | -122.389618578423 | (37.7361816375316, -122.389618578423) | 10 | 3 | 8 | 58 | 1 | |||
173294 | 200046 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1567 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015241.3298 | 2094241.268 | 37.7312440056702 | -122.389620392742 | (37.7312440056702, -122.389620392742) | 10 | 3 | 8 | 58 | 1 | |||
122181 | 196090 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015457.19385 | 2104954.19153 | 37.7606714353517 | -122.389622035738 | (37.7606714353517, -122.389622035738) | 10 | 3 | 8 | 28856 | 29 | |||
19250 | 79912 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015455.9807 | 2104968.54211 | 37.7607107716933 | -122.389627233809 | (37.7607107716933, -122.389627233809) | 10 | 3 | 8 | 28856 | 29 | |||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
13264 | 80600 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015454.07391 | 2105001.72353 | 37.7608017750127 | -122.389636146116 | (37.7608017750127, -122.389636146116) | 10 | 3 | 8 | 28856 | 29 | |||
13510 | 80601 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015453.52186 | 2105016.91626 | 37.7608434603734 | -122.38963911655 | (37.7608434603734, -122.38963911655) | 10 | 3 | 8 | 28856 | 29 | |||
19441 | 80602 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015452.48136 | 2105039.81643 | 37.7609062816229 | -122.389644314657 | (37.7609062816229, -122.389644314657) | 10 | 3 | 8 | 28856 | 29 | |||
13003 | 80604 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015452.956 | 2105074.08431 | 37.7610004001733 | -122.389645066492 | (37.7610004001733, -122.389645066492) | 10 | 3 | 8 | 28856 | 29 | |||
8811 | 80603 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015452.3757 | 2105055.85533 | 37.7609503151357 | -122.389645800319 | (37.7609503151357, -122.389645800319) | 10 | 3 | 8 | 28856 | 29 | |||
72891 | 196079 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Minnesota St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6015395.01764 | 2102273.41777 | 37.75330715422 | -122.389649840082 | (37.75330715422, -122.389649840082) | 10 | 3 | 8 | 28856 | 29 | ||||
120197 | 196078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Minnesota St | 7 | Front Yard : Yard | Tree | Private 2 | 4 | 6015385.56179 | 2102265.48112 | 37.7532848375261 | -122.389681986358 | (37.7532848375261, -122.389681986358) | 10 | 3 | 8 | 28856 | 29 | ||||
85672 | 38577 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1535 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40537 | 6015234.7344 | 2094950.5426 | 37.733191164968 | -122.389692714774 | (37.733191164968, -122.389692714774) | 10 | 3 | 8 | 58 | 1 | |
33841 | 38588 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40543 | 6015225.14493834 | 2094611.56119995 | 37.7322598587405 | -122.389702200572 | (37.7322598587405, -122.389702200572) | 10 | 3 | 8 | 58 | 1 | ||
156659 | 38583 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40543 | 6015225.14493834 | 2094611.56119995 | 37.7322598587405 | -122.389702200572 | (37.7322598587405, -122.389702200572) | 10 | 3 | 8 | 58 | 1 | ||
101748 | 196081 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Minnesota St | 27 | Front Yard : Yard | Tree | Private 2 | 6 | 6015382.92285 | 2102459.87565 | 37.7538184574574 | -122.389704688841 | (37.7538184574574, -122.389704688841) | 10 | 3 | 8 | 28856 | 29 | ||||
33996 | 196080 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Minnesota St | 26 | Front Yard : Yard | Tree | Private 2 | 4 | 6015379.26469 | 2102450.5128 | 37.7537925462017 | -122.389716685804 | (37.7537925462017, -122.389716685804) | 10 | 3 | 8 | 28856 | 29 | ||||
48179 | 38589 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1606 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40544 | 6015214.8687 | 2094687.4678 | 37.7324677131079 | -122.389743028049 | (37.7324677131079, -122.389743028049) | 10 | 3 | 8 | 58 | 1 | |
176962 | 200044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015203.4065 | 2094586.9741 | 37.732191142068 | -122.389775639203 | (37.732191142068, -122.389775639203) | 10 | 3 | 8 | 58 | 1 | |||
114213 | 38584 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015197.8625 | 2094625.984 | 37.7322979479453 | -122.389797530007 | (37.7322979479453, -122.389797530007) | 10 | 3 | 8 | 58 | 1 | |
106351 | 200045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1600 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015192.9639 | 2094571.5849 | 37.732148307342 | -122.389810667389 | (37.732148307342, -122.389810667389) | 10 | 3 | 8 | 58 | 1 | |||
12620 | 83942 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015103.3012 | 2090231.7832 | 37.7202271035042 | -122.389817632552 | (37.7202271035042, -122.389817632552) | 10 | 3 | 8 | 58 | 1 | |||
182048 | 49810 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 820 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015372.07913 | 2103953.65706 | 37.7579194622409 | -122.389846522708 | (37.7579194622409, -122.389846522708) | 10 | 3 | 8 | 28856 | 29 | |
38834 | 38585 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1601 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40543 | 6015181.5104 | 2094639.0656 | 37.7323329605685 | -122.389854976867 | (37.7323329605685, -122.389854976867) | 10 | 3 | 8 | 58 | 1 | |
78506 | 256036 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1547 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6015167 | 2093924 | 37.7303687297494 | -122.389855213397 | (37.7303687297494, -122.389855213397) | 10 | 3 | 8 | 58 | 1 |
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) );