Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, 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 | |||||||||
| 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 | |||||||||
| 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) | |
| 39598 | 39598 | 118510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 8137 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 5981731.77881 | 2112327.0562 | 37.778987433126105 | -122.50680790507 | (37.7789874331261, -122.50680790507) | |||
| 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) | |
| 166906 | 166906 | 183702 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1343 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5982736.6857 | 2105979.0791 | 37.7616168455095 | -122.502861540497 | (37.7616168455095, -122.502861540497) | |||
| 70334 | 70334 | 183703 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1343 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5982737.637 | 2105959.1018 | 37.76156204943371 | -122.502856771493 | (37.7615620494337, -122.502856771493) | |||
| 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) | ||
| 131275 | 131275 | 117894 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 559 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5984080.2137400005 | 2112029.0427099997 | 37.7783071869826 | -122.498661831158 | (37.7783071869826, -122.498661831158) | |||
| 136952 | 136952 | 183712 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3733 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984088.4104 | 2106972.4655 | 37.7644237543554 | -122.498259918056 | (37.7644237543554, -122.498259918056) | |||
| 163767 | 163767 | 183713 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3733 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5984106.6873 | 2106973.5567 | 37.7644278221565 | -122.49819678488501 | (37.7644278221565, -122.498196784885) | |||
| 63289 | 63289 | 118267 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5984728.94591 | 2111276.55423 | 37.776279095764 | -122.496362122462 | (37.776279095764, -122.496362122462) | |||
| 149564 | 149564 | 118268 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5984729.81712 | 2111254.48497 | 37.7762185509537 | -122.496357479966 | (37.7762185509537, -122.496357479966) | |||
| 180908 | 180908 | 184819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984690.0704 | 2106941.5787 | 37.764374208700104 | -122.496176694676 | (37.7643742087001, -122.496176694676) | |||
| 67988 | 67988 | 184818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984694.627 | 2106957.5269 | 37.7644182648708 | -122.49616211163 | (37.7644182648708, -122.49616211163) | |||
| 150757 | 150757 | 184890 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984711.7144 | 2106963.4126 | 37.7644354262232 | -122.496103446187 | (37.7644354262232, -122.496103446187) | |||
| 76533 | 76533 | 118256 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 747 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5985057.16315 | 2110772.73924 | 37.774914985746 | -122.49518958386001 | (37.774914985746, -122.49518958386) | |||
| 46368 | 46368 | 118255 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 747 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5985057.6853 | 2110754.64892 | 37.774865345470296 | -122.49518644334 | (37.7748653454703, -122.49518644334) | |||
| 185221 | 185221 | 78048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 783 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985063.43296 | 2110545.25732 | 37.7742907524801 | -122.495151117096 | (37.7742907524801, -122.495151117096) | ||
| 104125 | 104125 | 78350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 764 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 5 | 5985108.450019999 | 2110660.3816400003 | 37.7746094864044 | -122.49500388771901 | (37.7746094864044, -122.495003887719) | ||
| 45084 | 45084 | 69872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 3x3 | 5985114.18885 | 2110476.07325 | 37.774103764151896 | -122.49497044343599 | (37.7741037641519, -122.494970443436) | |
| 186314 | 186314 | 118191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5985457.0333 | 2109984.4342900002 | 37.7727739274481 | -122.49374826573299 | (37.7727739274481, -122.493748265733) | |||
| 29123 | 29123 | 186920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985200.7204 | 2096727.014 | 37.73635770677671 | -122.493657794712 | (37.7363577067767, -122.493657794712) | |||
| 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) |
| 156291 | 156291 | 250976 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985685.129819999 | 2113916.728 | 37.783584222178995 | -122.49324901662399 | (37.783584222179, -122.493249016624) | |||
| 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) | |
| 160175 | 160175 | 250975 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985704.58491 | 2113917.1556700002 | 37.7835865343301 | -122.49318174196699 | (37.7835865343301, -122.493181741967) | |||
| 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) | ||
| 70752 | 70752 | 250974 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985720.677490001 | 2113918.49675 | 37.78359115774511 | -122.493126167444 | (37.7835911577451, -122.493126167444) | |||
| 33448 | 33448 | 250973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5985735.07087 | 2113919.4528200002 | 37.7835946246316 | -122.493076443038 | (37.7835946246316, -122.493076443038) | |||
| 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) | ||
| 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) | |||
| 38838 | 38838 | 250972 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7010 California St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5985754.51701 | 2113919.45983 | 37.78359578115 | -122.493009168333 | (37.78359578115, -122.493009168333) | |||
| 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) | ||
| 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) | |||
| 56426 | 56426 | 250971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 7002 California St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5985825.16294 | 2113921.74383 | 37.783606183626105 | -122.492764932276 | (37.7836061836261, -122.492764932276) | |||
| 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) | |
| 177614 | 177614 | 119589 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5985952.115569999 | 2113870.87059 | 37.783473923115004 | -122.492321983626 | (37.783473923115, -122.492321983626) | |||
| 187734 | 187734 | 119588 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6945 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5985990.827880001 | 2113870.4748 | 37.7834750995118 | -122.49218802684099 | (37.7834750995118, -122.492188026841) | |||
| 29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
| 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) | |||
| 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) | |||
| 97747 | 97747 | 111712 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986078.0 | 2113222.0 | 37.7816996697749 | -122.491838693524 | (37.7816996697749, -122.491838693524) | ||||
| 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) | ||||
| 153181 | 153181 | 119587 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6915 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5986093.74324 | 2113874.71044 | 37.78349274505229 | -122.491832296674 | (37.7834927450523, -122.491832296674) | |||
| 55403 | 55403 | 250969 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6924 California St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5986098.00978 | 2113930.24714 | 37.7836454821978 | -122.49182162619199 | (37.7836454821978, -122.491821626192) | |||
| 55279 | 55279 | 250816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986143.35026 | 2114166.31593 | 37.7842963089792 | -122.491682151215 | (37.7842963089792, -122.491682151215) | |||
| 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) | |||
| 34041 | 34041 | 250815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986156.52823 | 2114164.57331 | 37.784292294401 | -122.491636432381 | (37.784292294401, -122.491636432381) | |||
| 73953 | 73953 | 250814 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 66 Sea View Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986166.78643 | 2114163.6239 | 37.7842902870978 | -122.491600873197 | (37.7842902870978, -122.491600873197) | |||
| 160860 | 160860 | 111711 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001x Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5986162.80344 | 2113197.5077400003 | 37.781637377269 | -122.491543514354 | (37.781637377269, -122.491543514354) | |||
| 71475 | 71475 | 119320 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5986187.45938 | 2113197.50531 | 37.7816388114384 | -122.491458217519 | (37.7816388114384, -122.491458217519) | |||
| 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) | |||
| 76263 | 76263 | 119383 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5986240.80118 | 2113637.97739 | 37.7828513382696 | -122.491306111206 | (37.7828513382696, -122.491306111206) | |||
| 29612 | 29612 | 119384 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5986242.52312 | 2113595.8501 | 37.78273576945529 | -122.491297052566 | (37.7827357694553, -122.491297052566) | |||
| 31024 | 31024 | 119385 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 340 31st Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5986245.2794 | 2113549.60335 | 37.7826089502225 | -122.491284112348 | (37.7826089502225, -122.491284112348) |
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");