trees

Custom SQL query returning 54 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2183 117295 6 17 130 CAMBON DR 1 Side Yard : Yard Tree 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
6580 261206 6 41 2301 Leavenworth St 1 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
7288 264692 6 172 1500 Plymouth Ave 1 Side Yard : Yard Tree 2       10x10   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
9703 264868 6 42 145 Guerrero St 1 Side Yard : Yard Tree 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
9964 262274 6 155 4 Montclair Ter 1 Side Yard : Yard Tree 2           6007298.70359 2120216.09204 37.8021211637502 -122.418921105258 (37.8021211637502, -122.418921105258) 5 1 1 28858 32
12152 255704 6 41 201X Hernandez Ave 1 Side Yard : Yard Tree 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
13002 260949 6 59 460x Davis Ct 1 Side Yard : Yard Tree 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
15148 260466 6 36 1 Masonic Ave 1 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
18711 262449 6 41 155 Baker St 1 Side Yard : Yard Tree 2       10x10   6000750.251 2109577.8851 37.7725404908768 -122.440818271359 (37.7725404908768, -122.440818271359) 15 5 11 29492 9
19052 260948 6 15 370 Drumm St 1 Side Yard : Yard Tree 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
19573 254456 6 113 1055X Duncan St 1 Side Yard : Yard Tree 2                              
39128 251719 6 155 1301 Clayton St 1 Side Yard : Yard Tree 2           5999055 2105304 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866) 15 5 5 28862 12
48743 253145 6 36 801X Santiago St 1 Side Yard : Yard Tree 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
63888 254137 6 15 1619 47th Ave 1 Side Yard : Yard Tree 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
69528 253807 6 93 2 Garfield St 1 Side Yard : Yard Tree 2       10x2 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
76823 255913 6 41 121 San Marcos Ave 1 Side Yard : Yard Tree 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
95967 254201 6 17 55X Aerial Way 1 Side Yard : Yard Tree 2       10x10 Permit Number 781191 5992360 2102538 37.7527294198072 -122.469328234463 (37.7527294198072, -122.469328234463) 1 8 4 56 12
106415 121157 6 11 350x Octavia St 1 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
126819 257966 6 35 98X Clearfield Dr 1 Side Yard : Yard Tree 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
133744 117251 6 63 2500x 34TH AVE 1 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
138786 255536 6 185 2783X Diamond St 1 Side Yard : Yard Tree 2       10x10 Permit Number 782107 6002654 2095945 37.7352160714264 -122.433258709098 (37.7352160714264, -122.433258709098) 2 7 5 63 7
142556 256880 6 59 2701 Alemany Blvd 1 Side Yard : Yard Tree 2       10x10   5997600 2087902 37.7128438731446 -122.450152604107 (37.7128438731446, -122.450152604107) 9 7 6 28861 25
157354 187637 6 41 875 El Camino Del Mar 1 Side Yard : Yard Tree 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
168009 254385 6 41 178X Warren Dr 1 Side Yard : Yard Tree 2       3x3   5995100 2102878 37.7538209308694 -122.459877514706 (37.7538209308694, -122.459877514706) 1 5 4 63 12
194273 263629 6 70 1985X Alemany Blvd 1 Side Yard : Yard Tree 2       10x10 Permit Number 785142 6000955 2090559 37.7203308201534 -122.438746936552 (37.7203308201534, -122.438746936552) 9 7 6 28861 25
194359 262298 6 17 1000X Mandalay Ln 1 Side Yard : Yard Tree 2   12/17/2020 12:00:00 AM 3 10x10 Permit Number 787936 5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
4419 260950 6 59 460x Davis Ct 2 Side Yard : Yard Tree 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
7030 260467 6 36 1 Masonic Ave 2 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15016 261205 6 36 2301 Leavenworth St 2 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
26477 253808 6 17 2 Garfield St 2 Side Yard : Yard Tree 2   09/14/2018 12:00:00 AM 3 10x10 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
51708 173779 6 322 99X Cleveland St 2 Side Yard : Yard Tree 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
106870 117252 6 63 2500x 34TH AVE 2 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
108809 187638 6 41 875 El Camino Del Mar 2 Side Yard : Yard Tree 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
188029 256520 6 185 2783X Diamond St 2 Side Yard : Yard Tree 2       10x10 Permit Number 782107 6002654 2095945 37.7352160714264 -122.433258709098 (37.7352160714264, -122.433258709098) 2 7 5 63 7
194054 121158 6 11 350x Octavia St 2 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
8743 261207 6 326 2301 Leavenworth St 3 Side Yard : Yard Tree 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
18482 260468 6 185 1 Masonic Ave 3 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
19367 254458 6 17 1055X Duncan St 3 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
77590 173780 6 57 99X Cleveland St 3 Side Yard : Yard Tree 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
78510 256521 6 185 2783X Diamond St 3 Side Yard : Yard Tree 2       10x10 Permit Number 782107 6002654 2095945 37.7352160714264 -122.433258709098 (37.7352160714264, -122.433258709098) 2 7 5 63 7
99672 121159 6 11 350x Octavia St 3 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
120070 253809 6 17 2 Garfield St 3 Side Yard : Yard Tree 2   09/14/2018 12:00:00 AM 3 10x10 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
176886 117253 6 63 2500x 34TH AVE 3 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
1408 260469 6 185 1 Masonic Ave 4 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16207 254459 6 17 1055X Duncan St 4 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
123818 121160 6 11 350x Octavia St 4 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
3184 260470 6 185 1 Masonic Ave 5 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
74407 121161 6 11 350x Octavia St 5 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
95557 114140 6 15 1200X JUNIPERO SERRA BLVD 5 Side Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
16147 260471 6 16 1 Masonic Ave 6 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
83376 121162 6 11 350x Octavia St 6 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
16043 260472 6 185 1 Masonic Ave 7 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
79081 121163 6 11 350x Octavia St 7 Side Yard : Yard Tree 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10