trees

Custom SQL query returning 39 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6867 260482 6 7 3333 California St 4 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
12545 260484 6 7 3333 California St 6 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
14823 260479 6 7 3333 California St 1 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
15393 260480 6 7 3333 California St 2 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
16021 260481 6 7 3333 California St 3 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
17369 260483 6 7 3333 California St 5 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
22 262394 6 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
5905 261162 6 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 10 3 8 58 1
9066 260960 6 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
129885 111357 6 15 600x MANSELL ST 1 Front Yard : Cutout Tree 1     48 3x3   6010142 2090267 37.7200474236955 -122.406969764511 (37.7200474236955, -122.406969764511) 10 3 8 309 28
144728 253098 6 15 1290 Portola Dr 2 Sidewalk: Property side : Yard Tree 1   08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
2201 107549 6 17 198X Jennings St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
36574 107552 6 17 1 Newhall St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
56372 107551 6 17 1 Newhall St 1 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
96773 92813 6 17 365 Fulton St 2 Sidewalk: Curb side : Cutout Tree 1       3x3 Permit Number 53020 6006011 2111744 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798) 7 9 11 28852 10
119862 107553 6 17 1 Newhall St 3 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
156782 12711 6 17 1449 Lake St 3 Front Yard : Cutout Tree 1   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046) 11 6 2 54 26
8787 260968 6 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10395 260478 6 41 3333 California St 8 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11407 260477 6 41 3333 California St 7 Sidewalk: Property side : Cutout Tree 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
130009 107550 6 52 198X Jennings St 3 Front Yard : Yard Tree 1           6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
178439 107539 6 52 198X JENNINGS ST 1 Front Yard : Yard Tree 1           6018784 2097136 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349) 10 3 8 58 1
3578 261993 6 93 1557x Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
11444 261994 6 93 1557x Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
17557 261982 6 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
17656 261984 6 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
73655 253718 6 110 227 Madison St 1 Sidewalk: Curb side : Cutout Tree 1 FUF     3x3 Permit Number 780760 6005690 2092595 37.7261894743752 -122.422524168298 (37.7261894743752, -122.422524168298) 9 7 7 309 5
4089 260964 6 121 1100x Vermont St 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4630 261689 6 121 1100x Vermont St 10 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
6430 260967 6 121 1100x Vermont St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
1871 261422 6 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2313 260963 6 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9216 261431 6 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10119 261688 6 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
138347 116585 6 146 2100 22nd St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2018 12:00:00 AM 30 3x3   6011855.05017 2103755.96694 37.7571809821214 -122.401996064067 (37.7571809821214, -122.401996064067) 10 3 8 28856 29
17502 260902 6 184 1901 Geary Blvd 1 Sidewalk: Property side : Cutout Tree 1       Width 0ft   6002672 2113572 37.7836165897996 -122.434456380093 (37.7836165897996, -122.434456380093) 13 9 11 29490 41
13844 260966 6 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14462 261432 6 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16010 260965 6 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19