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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
9595 | 9595 | 35817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
12686 | 12686 | 35818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
13881 | 13881 | 35819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
15498 | 15498 | 35820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 980 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39055 | ||||||||
15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
45359 | 45359 | 68576 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 32 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32469 | 5981483.59375 | 2111332.3319599996 | 37.776241595894106 | -122.50759263196899 | (37.7762415958941, -122.507592631969) | |
25488 | 25488 | 39821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2101 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | 3 | Permit Number 41148 | 5981982.6078 | 2100745.8281 | 37.7472034694978 | -122.505081701882 | (37.7472034694978, -122.505081701882) | ||
187206 | 187206 | 47445 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 811 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45355 | 5982594.30489 | 2110210.15333 | 37.77322578967961 | -122.50366731846701 | (37.7732257896796, -122.503667318467) | |
38284 | 38284 | 67224 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30683 | 5983507.38436 | 2109708.43135 | 37.771901847852895 | -122.500471801712 | (37.7719018478529, -122.500471801712) | |
184032 | 184032 | 57999 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 871 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1977 12:00:00 AM | 19 | Permit Number 16964 | 5983538.74255 | 2109889.72287 | 37.772401462891004 | -122.50037673928499 | (37.772401462891, -122.500376739285) | ||
107253 | 107253 | 20476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
115969 | 115969 | 20467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
146051 | 146051 | 20469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
80842 | 80842 | 20504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | ||
11168 | 11168 | 66002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1242 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1990 12:00:00 AM | 14 | 3x3 | Permit Number 29036 | 5985545.5711 | 2106756.716 | 37.7639167014529 | -122.493204178844 | (37.7639167014529, -122.493204178844) | |
112647 | 112647 | 69453 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 459 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 15 | 6x9 | Permit Number 33563 | 5985605.84685 | 2112812.05347 | 37.780546467003 | -122.49344188362801 | (37.780546467003, -122.493441883628) |
170541 | 170541 | 48891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985690.94714 | 2113237.00512 | 37.781718239515705 | -122.49317880031299 | (37.7817182395157, -122.493178800313) | ||
186039 | 186039 | 48890 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985723.18076 | 2113238.27416 | 37.781723609133394 | -122.493067382279 | (37.7817236091334, -122.493067382279) | ||
72307 | 72307 | 48889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985750.33557 | 2113240.82458 | 37.7817321999331 | -122.49297362868799 | (37.7817321999331, -122.492973628688) | ||
93722 | 93722 | 3433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
95203 | 95203 | 3434 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
112668 | 112668 | 3432 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
114435 | 114435 | 3436 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
122785 | 122785 | 3435 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7050X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | |||
65973 | 65973 | 32610 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37075 | 5985761.6347 | 2106405.465 | 37.762964898882295 | -122.49243102202699 | (37.7629648988823, -122.492431022027) | |
132866 | 132866 | 32609 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37075 | 5985785.2482 | 2106404.8747 | 37.762964658627 | -122.492349308745 | (37.762964658627, -122.492349308745) | |
33534 | 33534 | 48888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985804.5371900005 | 2113240.84362 | 37.7817354218334 | -122.492786120653 | (37.7817354218334, -122.492786120653) | ||
140402 | 140402 | 3429 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7004 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5985822.36441 | 2113950.31704 | 37.783684473765994 | -122.492776719205 | (37.783684473766, -122.492776719205) | |||
87931 | 87931 | 3427 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6935 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5986031.23866 | 2113812.47414 | 37.7833182086658 | -122.49204395142799 | (37.7833182086658, -122.492043951428) | |||
122234 | 122234 | 104348 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001X Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5986078.49957 | 2113222.60189 | 37.781701351590705 | -122.49183700959601 | (37.7817013515907, -122.491837009596) | ||||
140954 | 140954 | 104349 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001X Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x9 | 5986078.49957 | 2113222.60189 | 37.781701351590705 | -122.49183700959601 | (37.7817013515907, -122.491837009596) | ||||
142193 | 142193 | 3426 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6923 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5986081.208380001 | 2113814.2097 | 37.783325894808 | -122.491871206253 | (37.783325894808, -122.491871206253) | |||
110395 | 110395 | 3425 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6909 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3X3 | 5986140.62624 | 2113874.1409400003 | 37.7834939214569 | -122.49167006003599 | (37.7834939214569, -122.491670060036) | |||
60770 | 60770 | 104346 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 417 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x9 | 5986214.274119999 | 2113133.51512 | 37.7814646796583 | -122.491360741327 | (37.7814646796583, -122.491360741327) | |||
161274 | 161274 | 104347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 417 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x9 | 5986214.92159 | 2113090.52274 | 37.78134667274529 | -122.49135533616999 | (37.7813466727453, -122.49135533617) | |||
129062 | 129062 | 718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986263.20776 | 2113937.4435799997 | 37.783674895540706 | -122.491250641927 | (37.7836748955407, -122.491250641927) | |||
107078 | 107078 | 84309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51853 | 5986320.037019799 | 2110116.74258849 | 37.7731876600069 | -122.49077281705 | (37.7731876600069, -122.49077281705) | ||
126148 | 126148 | 3424 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6833 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986349.10744 | 2113885.75045 | 37.7835379798624 | -122.490949660605 | (37.7835379798624, -122.490949660605) | |||
152604 | 152604 | 84305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 846 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51905 | 5986366.33203 | 2110148.04849 | 37.77327632146471 | -122.490614982457 | (37.7732763214647, -122.490614982457) | |
119423 | 119423 | 721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6859X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986379.68484 | 2113889.27863 | 37.783549453567 | -122.49084413577101 | (37.783549453567, -122.490844135771) | |||
128102 | 128102 | 715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986402.41509 | 2113942.22606 | 37.7836961598318 | -122.490769396103 | (37.7836961598318, -122.490769396103) | |||
143831 | 143831 | 3423 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6815 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986408.872219999 | 2113888.5255400003 | 37.7835490908414 | -122.490743104657 | (37.7835490908414, -122.490743104657) | |||
126365 | 126365 | 3422 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6809 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5986450.76116 | 2113888.56834 | 37.7835516552386 | -122.49059819022699 | (37.7835516552386, -122.490598190227) | |||
128019 | 128019 | 714 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x33 | 5986452.35935 | 2113947.57202 | 37.7837137557398 | -122.490597003715 | (37.7837137557398, -122.490597003715) | |||
59199 | 59199 | 42278 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1646 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 5 | Permit Number 46652 | 5986569.425 | 2104035.4361 | 37.756504646339394 | -122.489462910282 | (37.7565046463394, -122.489462910282) | |
81785 | 81785 | 3421 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6743 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 5986605.45058 | 2113893.32578 | 37.7835737522145 | -122.490063381826 | (37.7835737522145, -122.490063381826) | |||
104601 | 104601 | 3419 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6705 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986705.37127 | 2113895.64572 | 37.7835859565372 | -122.48971787002199 | (37.7835859565372, -122.489717870022) | |||
141614 | 141614 | 710 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5 | 5986716.67704 | 2113957.13547 | 37.783755449840996 | -122.489683280356 | (37.783755449841, -122.489683280356) | |||
125712 | 125712 | 3420 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6705 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986754.0629 | 2113899.4309400003 | 37.783599192434394 | -122.489549696395 | (37.7835991924344, -122.489549696395) | |||
94870 | 94870 | 711 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
140386 | 140386 | 712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
95943 | 95943 | 3414 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6641 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5986907.819080001 | 2113905.3081099996 | 37.783624304644 | -122.489018198295 | (37.783624304644, -122.489018198295) | |||
93958 | 93958 | 3415 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6641 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5986955.69055 | 2113907.40325 | 37.783632851202796 | -122.488852737582 | (37.7836328512028, -122.488852737582) | |||
84292 | 84292 | 3416 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
91064 | 91064 | 3417 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
93802 | 93802 | 3418 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6650X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 5 | 5986981.14006 | 2113960.8042599997 | 37.7837809602941 | -122.48876861975401 | (37.7837809602941, -122.488768619754) | |||
80971 | 80971 | 3413 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6625 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 2X2 | 5987004.51958 | 2113910.41235 | 37.7836439628806 | -122.48868403128401 | (37.7836439628806, -122.488684031284) | |||
85390 | 85390 | 705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
126299 | 126299 | 704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
83749 | 83749 | 3412 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6619 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 5987053.9069300005 | 2113910.29646 | 37.7836465265666 | -122.488513163635 | (37.7836465265666, -122.488513163635) | |||
131166 | 131166 | 37240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 10 | Permit Number 39797 | 5987223.0879999995 | 2103734.1389 | 37.7557155042777 | -122.48718021225599 | (37.7557155042777, -122.487180212256) | ||
51809 | 51809 | 37233 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 10 | Permit Number 39797 | 5987275.2123 | 2103735.3235 | 37.755721796170796 | -122.487000039163 | (37.7557217961708, -122.487000039163) | ||
82167 | 82167 | 3409 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6525 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 2X3 | 5987276.92866 | 2113919.53394 | 37.7836849008923 | -122.487742282465 | (37.7836849008923, -122.487742282465) | |||
126525 | 126525 | 3410 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6528 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5987293.52978 | 2113992.8320400002 | 37.7838871248275 | -122.48769023634199 | (37.7838871248275, -122.487690236342) | |||
44159 | 44159 | 37237 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 11 | Permit Number 39797 | 5987327.3366 | 2103738.2851 | 37.755732966947896 | -122.486819996525 | (37.7557329669479, -122.486819996525) | ||
143328 | 143328 | 3408 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6517 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X3 | 5987328.28355 | 2113919.47268 | 37.7836877279639 | -122.48756461184999 | (37.7836877279639, -122.48756461185) | |||
82277 | 82277 | 3411 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6535 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X3 | 5987339.6073 | 2113923.58255 | 37.7836996729153 | -122.487525738493 | (37.7836996729153, -122.487525738493) | |||
117370 | 117370 | 3406 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6509 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5987365.26176 | 2113921.59773 | 37.783695719333004 | -122.487436839088 | (37.783695719333, -122.487436839088) | |||
109945 | 109945 | 3407 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6509 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5987381.40448 | 2113921.43328 | 37.7836962092086 | -122.487380980037 | (37.7836962092086, -122.487380980037) | |||
112196 | 112196 | 3405 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6469 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5987528.04768 | 2113893.30009 | 37.7836275141903 | -122.486871590011 | (37.7836275141903, -122.486871590011) | |||
145876 | 145876 | 3403 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6434 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3PL | 5987566.03315 | 2113985.09722 | 37.7838817775015 | -122.48674691948798 | (37.7838817775015, -122.486746919488) |
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");