trees
953 rows where qSpecies_id = 60 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
26153 | 108935 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12X CAMP ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005858 | 2106413 | 37.7641400388714 | -122.422925047265 | (37.7641400388714, -122.422925047265) | 8 | 4 | 5 | 28859 | 19 | ||||
30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
39542 | 254749 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 164 Escolta Way | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 4x6 | Permit Number 781597 | 5986451.85258 | 2097316.8045 | 37.7380502293434 | -122.489375519691 | (37.7380502293434, -122.489375519691) | 1 | 8 | 3 | 29491 | 35 | |
54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
70383 | 104503 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 157 ALBION ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6005993 | 2106325 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | 8 | 4 | 5 | 28859 | 19 | ||||
72634 | 104807 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2069 GREEN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003141.4 | 2118171.7 | 37.7962728265697 | -122.433161198258 | (37.7962728265697, -122.433161198258) | 13 | 9 | 1 | 57 | 17 | ||||||
74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
111726 | 108723 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.397959844253 | (37.7565264696642, -122.397959844253) | 10 | 3 | 8 | 28856 | 29 | |
125967 | 96999 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
711 | 57691 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759 | 2096663 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | 2 | 7 | 5 | 63 | 7 | |
953 | 4237 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4018 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003765.90932 | 2100430.48709 | 37.747595203776 | -122.429734255035 | (37.747595203776, -122.429734255035) | 2 | 4 | 5 | 63 | 22 | |||
1130 | 54772 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.462820895269 | (37.7614415732371, -122.462820895269) | 1 | 5 | 11 | 56 | 12 | ||
1204 | 72270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | 9 | 7 | 6 | 28861 | 5 | |||
1684 | 65960 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.7404829512667 | -122.484029196034 | (37.7404829512667, -122.484029196034) | 1 | 8 | 3 | 29491 | 35 | |
2325 | 204652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 01:08:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.7193758368067 | -122.451924066956 | (37.7193758368067, -122.451924066956) | 9 | 8 | 6 | 28861 | 24 | ||
2438 | 262446 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | 6001156 | 2093630 | 37.7287745209628 | -122.438272037819 | (37.7287745209628, -122.438272037819) | 9 | 7 | 6 | 28861 | 25 | |||
2627 | 44717 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.478457743126 | (37.7506108546658, -122.478457743126) | 1 | 8 | 3 | 29491 | 35 | ||
2854 | 255187 | Section 806 (d) 5 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4740 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780757 | 5980843 | 2110991 | 37.7752666409579 | -122.509783220192 | (37.7752666409579, -122.509783220192) | 11 | 6 | 2 | 55 | 26 | |
3037 | 73418 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983001.5767 | 2098246.6338 | 37.7404012697688 | -122.50137340388 | (37.7404012697688, -122.50137340388) | 1 | 8 | 3 | 29491 | 35 | |||
3060 | 70445 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982997.1409 | 2098317.8833 | 37.7405966408958 | -122.501394010052 | (37.7405966408958, -122.501394010052) | 1 | 8 | 3 | 29491 | 35 | |||
3893 | 78349 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | 11 | 6 | 2 | 55 | 26 | |||
4049 | 185126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | 1 | 8 | 3 | 64 | 35 | |||
4319 | 71268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | 15 | 5 | 11 | 29492 | 16 | |||
4688 | 204667 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.450748183599 | (37.7330989075759, -122.450748183599) | 9 | 7 | 4 | 59 | 40 | |||
4922 | 152652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6008666.19749 | 2102064.94601 | 37.75235932814 | -122.412904832409 | (37.75235932814, -122.412904832409) | 2 | 4 | 7 | 28859 | 19 | |||
5060 | 141961 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | 7 | 9 | 11 | 28852 | 41 | |||
5626 | 52490 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | ||
6168 | 107105 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 532 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.7603508695767 | -122.432887270079 | (37.7603508695767, -122.432887270079) | 2 | 4 | 5 | 28862 | 3 | |||
8029 | 70268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002561.31186 | 2089826.69987 | 37.7184113400032 | -122.433142152308 | (37.7184113400032, -122.433142152308) | 9 | 7 | 6 | 28861 | 5 | |||
8402 | 164235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2443 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5991051.37597 | 2098768.01272 | 37.7423023040997 | -122.473578669836 | (37.7423023040997, -122.473578669836) | 1 | 8 | 4 | 29491 | 40 | |||
8829 | 141965 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | 7 | 9 | 11 | 28852 | 41 | |||
8978 | 71997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | 11 | 6 | 2 | 55 | 26 | |||
9074 | 27096 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 707 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6006037.72373 | 2093592.89407 | 37.7289490840269 | -122.421392939642 | (37.7289490840269, -122.421392939642) | 9 | 7 | 6 | 28861 | 5 | ||
9301 | 27189 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 262 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002929.54622 | 2093714.91608 | 37.7291083953197 | -122.432146839331 | (37.7291083953197, -122.432146839331) | 9 | 7 | 6 | 28861 | 25 | ||
10040 | 188312 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012939.88574 | 2105717.83125 | 37.7626283178769 | -122.398381909999 | (37.7626283178769, -122.398381909999) | 14 | 3 | 8 | 28856 | 29 | |||
10865 | 260932 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 249 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001134 | 2098325 | 37.7416646487467 | -122.438684376046 | (37.7416646487467, -122.438684376046) | 2 | 7 | 5 | 63 | 7 | ||||
11233 | 112393 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4127 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002153 | 2105221 | 37.7606573415981 | -122.435654265974 | (37.7606573415981, -122.435654265974) | 2 | 4 | 5 | 28862 | 3 | ||||
11333 | 222507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.408160091111 | (37.7518194273238, -122.408160091111) | 2 | 4 | 7 | 28859 | 19 | |||
11406 | 72840 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | 1 | 8 | 3 | 29491 | 35 | |||
12444 | 260536 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5983685.38782 | 2106695.21091 | 37.7636388518254 | -122.499633347112 | (37.7636388518254, -122.499633347112) | 1 | 8 | 3 | 56 | 35 | ||||
12538 | 38150 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 12:00:00 AM | 3 | 3x5 | Permit Number 780230 | 6010281.37407 | 2093721.85483 | 37.7295415331127 | -122.406731343599 | (37.7295415331127, -122.406731343599) | 10 | 3 | 7 | 309 | 28 |
12850 | 222577 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002861.59805 | 2105354.01605 | 37.7610627942241 | -122.433213052158 | (37.7610627942241, -122.433213052158) | 15 | 4 | 5 | 28862 | 3 | |||
13343 | 69152 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.7640417272514 | -122.48906697906 | (37.7640417272514, -122.48906697906) | 1 | 8 | 3 | 56 | 35 | |
13532 | 170412 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 418 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6002130.67335 | 2093947.3581 | 37.7297013021565 | -122.434925220129 | (37.7297013021565, -122.434925220129) | 9 | 7 | 6 | 28861 | 25 | ||
14406 | 165740 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 119 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007607.32013 | 2098066.61783 | 37.7413213218322 | -122.41628344773 | (37.7413213218322, -122.41628344773) | 2 | 7 | 7 | 28859 | 2 | |||
14860 | 144376 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 390 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5986872.03276 | 2113312.07102 | 37.7819933565565 | -122.489098375585 | (37.7819933565565, -122.489098375585) | 11 | 6 | 2 | 55 | 26 | |||
15869 | 261717 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1983 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2020 12:00:00 AM | 3 | 4x4 | 5987209 | 2101791 | 37.7503793489945 | -122.487086227612 | (37.7503793489945, -122.487086227612) | 1 | 8 | 3 | 29491 | 35 | |
16342 | 71996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989363.9833 | 2113075.99146 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | 11 | 6 | 2 | 55 | 26 | |||
16761 | 72980 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.485044488235 | (37.7550761133303, -122.485044488235) | 1 | 8 | 3 | 56 | 35 | |||
16961 | 261483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
17491 | 256739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1315 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 5989553.93379 | 2106395.50264 | 37.763158533492 | -122.479314183035 | (37.763158533492, -122.479314183035) | 1 | 8 | 3 | 56 | 35 | ||
17506 | 32483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.38914 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | 15 | 5 | 5 | 28862 | 3 | |
17900 | 262447 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 31 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001222 | 2093679 | 37.7289128173751 | -122.4380473805 | (37.7289128173751, -122.4380473805) | 9 | 7 | 6 | 28861 | 25 | ||
18161 | 56725 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015793.5491 | 2095580.2933 | 37.7349513047544 | -122.387804649295 | (37.7349513047544, -122.387804649295) | 10 | 3 | 8 | 58 | 1 | ||||
19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
19828 | 27132 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.68156 | 2095938.36762 | 37.7357362666047 | -122.400161784365 | (37.7357362666047, -122.400161784365) | 10 | 3 | 8 | 58 | 1 | ||
19959 | 27186 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 246 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2x3 | 6002844.31593 | 2093767.70456 | 37.7292485078886 | -122.432445255941 | (37.7292485078886, -122.432445255941) | 9 | 7 | 6 | 28861 | 25 | ||
20019 | 66828 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | 15 | 6 | 2 | 54 | 16 | |
20379 | 221335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1641 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010542.34793 | 2100138.19824 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | 2 | 7 | 7 | 28859 | 2 | |||
20518 | 188347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 83 Scotia Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | 10 | 3 | 8 | 58 | 1 | |||
21788 | 26984 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1381 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009547.85305 | 2094416.1727 | 37.7314069136466 | -122.409316188794 | (37.7314069136466, -122.409316188794) | 9 | 3 | 7 | 309 | 28 | ||
22182 | 246011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | 15 | 5 | 11 | 29492 | 9 | |
22794 | 188356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017138.82287 | 2095616.15283 | 37.7351241988078 | -122.383156012747 | (37.7351241988078, -122.383156012747) | 10 | 3 | 8 | 58 | 1 | |||
22879 | 248397 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | 15 | 5 | 11 | 29492 | 9 | |||
22997 | 26483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846 | (37.7426474144589, -122.43907493846) | 2 | 7 | 5 | 63 | 7 | ||
23180 | 27013 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1500 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2004 12:00:00 AM | 6 | 3X3 | 6010352.81235 | 2094643.09069 | 37.7320750491485 | -122.406549264372 | (37.7320750491485, -122.406549264372) | 10 | 3 | 7 | 309 | 28 | ||
23186 | 103507 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
23911 | 96839 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009509 | 2097504 | 37.7398832463975 | -122.409668377616 | (37.7398832463975, -122.409668377616) | 10 | 7 | 7 | 28859 | 2 | |||
23954 | 221341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.425437478672 | (37.7469275767478, -122.425437478672) | 2 | 7 | 5 | 63 | 22 | |||
23979 | 27086 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 743X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006263.01382 | 2093613.97451 | 37.7290196659204 | -122.420615589747 | (37.7290196659204, -122.420615589747) | 9 | 7 | 6 | 28861 | 5 | ||
24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
24194 | 32579 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.7638481208517 | -122.492272911774 | (37.7638481208517, -122.492272911774) | 1 | 8 | 3 | 56 | 35 | |
24217 | 221347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558 | (37.7378588087266, -122.41024559558) | 10 | 7 | 7 | 28859 | 2 | |||
24389 | 221356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008902.61993 | 2103693.22479 | 37.7568434827621 | -122.412202312603 | (37.7568434827621, -122.412202312603) | 2 | 4 | 7 | 28859 | 19 | |||
24479 | 188293 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 1 | : | Tree | Private 2 | 19 | Width 5ft | 6008175.89918 | 2108871.24729 | 37.7710203298423 | -122.415082093787 | (37.7710203298423, -122.415082093787) | 8 | 2 | 9 | 28853 | 19 | |||
24510 | 204663 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000334.21865 | 2095199.11319 | 37.7330361672695 | -122.44122551784 | (37.7330361672695, -122.44122551784) | 9 | 7 | 5 | 63 | 40 | ||||
24546 | 22552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | 2 | 7 | 5 | 63 | 7 | ||
24955 | 26493 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.7761801200302 | -122.426279843947 | (37.7761801200302, -122.426279843947) | 7 | 9 | 11 | 28852 | 10 | |||
25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
25483 | 56043 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4129 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 9 | 3x3 | Permit Number 12130 | 6002248.77832892 | 2105270.36244465 | 37.7607983186187 | -122.435326543463 | (37.7607983186187, -122.435326543463) | 2 | 4 | 5 | 28862 | 3 | |
25487 | 222564 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007476.41433 | 2100201.58357 | 37.7471760989928 | -122.416887300207 | (37.7471760989928, -122.416887300207) | 2 | 7 | 7 | 28859 | 2 | |||
26108 | 204620 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | 1 | 8 | 4 | 56 | 12 | |||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
26763 | 54426 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.7588416315494 | -122.400163199892 | (37.7588416315494, -122.400163199892) | 10 | 3 | 8 | 28856 | 29 | |
26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
28325 | 26998 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.412124661535 | (37.7303936047791, -122.412124661535) | 9 | 3 | 7 | 309 | 28 | ||
28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
28920 | 204622 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.464883245465 | (37.7599558699739, -122.464883245465) | 1 | 8 | 4 | 56 | 12 | |||
29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
29421 | 107444 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3333 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x6 | 6006088.7 | 2103711.1 | 37.7567342687503 | -122.421935176249 | (37.7567342687503, -122.421935176249) | 2 | 4 | 5 | 28859 | 19 | |||
29876 | 204614 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | 1 | 8 | 4 | 56 | 12 | |||
30252 | 57436 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 10 | 3x3 | Permit Number 32868 | 6001612.33019827 | 2105235.34197744 | 37.7606659965109 | -122.437525222221 | (37.7606659965109, -122.437525222221) | 2 | 4 | 5 | 28862 | 3 |
30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
31225 | 204651 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 27 Majestic Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.450979745524 | (37.7179774953307, -122.450979745524) | 9 | 8 | 6 | 28861 | 24 | |||
32161 | 123707 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 698 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5993511.46751 | 2111432.07 | 37.7772166713285 | -122.465992510852 | (37.7772166713285, -122.465992510852) | 11 | 6 | 2 | 54 | 11 | |||
32334 | 221326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | 2 | 4 | 5 | 28859 | 19 |
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) );