Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
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 | |||||||||
8246 | 8246 | 20349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
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 | |||||||||
9565 | 9565 | 20409 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
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 | ||||||||
9606 | 9606 | 20333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
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 | |||||||||
10242 | 10242 | 20328 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
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 | ||||||||||
11483 | 11483 | 20348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
12000 | 12000 | 20347 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 8 | ||||||||
12183 | 12183 | 20411 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
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 | |||||||||
12674 | 12674 | 20327 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
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 | ||||||||
12828 | 12828 | 20459 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 495X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
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 | ||||||||
14471 | 14471 | 20350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
14576 | 14576 | 20410 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
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 | |||||||||
18528 | 18528 | 120131 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
20185 | 20185 | 120130 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
101348 | 101348 | 27884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.4130000002 | 37.5090039879895 | -122.38142014589701 | (37.5090039879895, -122.381420145897) | |||
77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
72189 | 72189 | 178591 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 67 Belle Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5991713.92465 | 2086485.44715 | 37.70861577046671 | -122.470393502266 | (37.7086157704667, -122.470393502266) | |||
137765 | 137765 | 178592 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 67 Belle Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5991724.32675 | 2086485.2281099998 | 37.7086157704725 | -122.470357535671 | (37.7086157704725, -122.470357535671) | |||
162521 | 162521 | 178554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007838.70528 | 2086225.04271 | 37.7088198950039 | -122.414645608726 | (37.7088198950039, -122.414645608726) | |||
52100 | 52100 | 178508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007843.72677 | 2086231.7813400002 | 37.708838680016704 | -122.414628730257 | (37.7088386800167, -122.414628730257) | |||
188869 | 188869 | 178549 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008341.68171 | 2086226.9900599997 | 37.7088534882771 | -122.412907384688 | (37.7088534882771, -122.412907384688) | |||
156719 | 156719 | 178517 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6008541.04755 | 2086224.10569 | 37.708856757315395 | -122.41221814244801 | (37.7088567573154, -122.412218142448) | |||
119122 | 119122 | 178548 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008543.60628 | 2086225.1928599998 | 37.7088598860379 | -122.412209375875 | (37.7088598860379, -122.412209375875) | |||
145728 | 145728 | 178555 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 580 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007810.831590001 | 2086243.5160299998 | 37.708869052843 | -122.414743250798 | (37.708869052843, -122.414743250798) | |||
10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
147503 | 147503 | 178547 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008553.87122 | 2086250.69527 | 37.7089304864164 | -122.412175699859 | (37.7089304864164, -122.412175699859) | |||
76451 | 76451 | 178516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6008552.66413 | 2086251.2184400002 | 37.70893185520271 | -122.41217990870001 | (37.7089318552027, -122.4121799087) | |||
32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
70516 | 70516 | 178550 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008247.372380001 | 2086262.5391799998 | 37.7089458045697 | -122.413235844076 | (37.7089458045697, -122.413235844076) | |||
62440 | 62440 | 178519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | |||
166145 | 166145 | 178551 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008208.8909599995 | 2086276.4009099999 | 37.70898170551929 | -122.413369821453 | (37.7089817055193, -122.413369821453) | |||
55176 | 55176 | 178556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 550 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007824.59893 | 2086288.7583 | 37.708994052312 | -122.414698868372 | (37.708994052312, -122.414698868372) | |||
34606 | 34606 | 178520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008160.20585 | 2086291.9091900003 | 37.7090215544595 | -122.413539180899 | (37.7090215544595, -122.413539180899) | |||
70765 | 70765 | 178552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 80 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008167.33564 | 2086292.8160599999 | 37.7090244448819 | -122.413514603312 | (37.7090244448819, -122.413514603312) | |||
150256 | 150256 | 178521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008137.560430001 | 2086303.76828 | 37.7090528454867 | -122.413618285264 | (37.7090528454867, -122.413618285264) | |||
167412 | 167412 | 178553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008120.85709 | 2086313.06742 | 37.7090774410456 | -122.413676671965 | (37.7090774410456, -122.413676671965) | |||
166675 | 166675 | 178558 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 525 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007875.12546 | 2086323.01846 | 37.7090909623615 | -122.414526663487 | (37.7090909623615, -122.414526663487) | |||
2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
173412 | 173412 | 178557 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 520 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007843.02927 | 2086335.9512200002 | 37.709124669828796 | -122.41463850766199 | (37.7091246698288, -122.414638507662) | |||
34590 | 34590 | 178546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008580.640819999 | 2086320.97824 | 37.709124971097296 | -122.412088143666 | (37.7091249710973, -122.412088143666) | |||
168228 | 168228 | 178515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6008576.98547 | 2086321.37555 | 37.709125856931706 | -122.41210080521601 | (37.7091258569317, -122.412100805216) | |||
173162 | 173162 | 178509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 515 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007885.078480001 | 2086346.0784099998 | 37.7091548393851 | -122.41449389489901 | (37.7091548393851, -122.414493894899) | |||
131663 | 131663 | 178559 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 505 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007887.65657 | 2086358.0557400002 | 37.7091878714972 | -122.414485831553 | (37.7091878714972, -122.414485831553) | |||
184151 | 184151 | 178510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 505 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007893.56338 | 2086370.2440099998 | 37.709221669809104 | -122.414466278505 | (37.7092216698091, -122.414466278505) | |||
54550 | 54550 | 178562 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 480 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007827.05834 | 2086383.84807 | 37.709255287375996 | -122.414697093097 | (37.709255287376, -122.414697093097) | |||
55681 | 55681 | 178511 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 541 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007882.79465 | 2086395.27125 | 37.7092897844697 | -122.414505266807 | (37.7092897844697, -122.414505266807) | |||
32710 | 32710 | 178563 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 480 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007783.22647 | 2086400.60158 | 37.70929882625379 | -122.414849768326 | (37.7092988262538, -122.414849768326) | |||
166470 | 166470 | 178560 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 445 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007876.17075 | 2086399.2113299998 | 37.7093002309861 | -122.414528438753 | (37.7093002309861, -122.414528438753) | |||
154364 | 154364 | 178512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 439 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007843.62507 | 2086410.5828099998 | 37.7093296262441 | -122.41464172634599 | (37.7093296262441, -122.414641726346) | |||
26302 | 26302 | 178561 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 439 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007844.07465 | 2086412.1441 | 37.709333938483205 | -122.414640282934 | (37.7093339384832, -122.414640282934) | |||
75585 | 75585 | 178565 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 460 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007731.20011 | 2086418.54573 | 37.7093451736989 | -122.41503084952 | (37.7093451736989, -122.41503084952) | |||
177503 | 177503 | 178590 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 162 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008387.31542 | 2086415.8204700002 | 37.70937453926629 | -122.412763008431 | (37.7093745392663, -122.412763008431) | |||
154839 | 154839 | 178566 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 440 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007693.49818 | 2086433.63947 | 37.7093844992558 | -122.415162221581 | (37.7093844992558, -122.415162221581) | |||
186646 | 186646 | 178513 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 415 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007751.28679 | 2086446.17262 | 37.7094221601795 | -122.414963380574 | (37.7094221601795, -122.414963380574) | |||
55347 | 55347 | 178564 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 415 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007748.23718 | 2086447.86448 | 37.709426634310105 | -122.41497404023 | (37.7094266343101, -122.41497404023) | |||
172146 | 172146 | 178589 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 148 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008325.30704 | 2086437.13013 | 37.709429570584 | -122.412978825937 | (37.709429570584, -122.412978825937) | |||
65454 | 65454 | 178567 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007708.5234 | 2086465.04543 | 37.709471577916396 | -122.415112513358 | (37.7094715779164, -122.415112513358) | |||
184994 | 184994 | 178588 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 142 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008281.79574 | 2086454.4645200002 | 37.709474724661206 | -122.413130433618 | (37.7094747246612, -122.413130433618) | |||
66536 | 66536 | 178514 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007703.2956 | 2086466.8133200002 | 37.709476138386606 | -122.41513070661999 | (37.7094761383866, -122.41513070662) | |||
116930 | 116930 | 178587 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 130 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008235.1788099995 | 2086471.34858 | 37.7095184676674 | -122.41329274328001 | (37.7095184676674, -122.41329274328) | |||
165834 | 165834 | 178538 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 221 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999964.31362 | 2086649.6943 | 37.709540337400604 | -122.44189096669201 | (37.7095403374006, -122.441890966692) | |||
51568 | 51568 | 178568 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 324 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007682.95212 | 2086548.4325400002 | 37.7096991045948 | -122.415206791063 | (37.7096991045948, -122.415206791063) | |||
39330 | 39330 | 178586 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008179.939230001 | 2086593.1846599998 | 37.7098499029291 | -122.413492272274 | (37.7098499029291, -122.413492272274) | |||
137628 | 137628 | 178585 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 38 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008197.36949 | 2086639.4956 | 37.7099780419221 | -122.413435302895 | (37.7099780419221, -122.413435302895) |
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");