trees

Custom SQL query returning 32 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
42527 207128 1 47 2 Cranleigh Dr 1 Front Yard : Yard Tree 2     15 Width 0ft   5991324.62806 2095649.61894 37.7337558092758 -122.472406573513 (37.7337558092758, -122.472406573513) 1 8 4 64 40
13132 207127 1 47 2 Cranleigh Dr 2 Front Yard : Yard Tree 2     4 Width 0ft   5991327.69264 2095651.06492 37.7337599569436 -122.472396083831 (37.7337599569436, -122.472396083831) 1 8 4 64 40
172236 207126 1 47 2 Cranleigh Dr 3 Front Yard : Yard Tree 1   08/18/2016 09:59:00 AM 13 Width 0ft   5991329.52565 2095655.77453 37.7337729944342 -122.472390089849 (37.7337729944342, -122.472390089849) 1 8 4 64 40
183941 207125 1 47 2 Cranleigh Dr 4 Front Yard : Yard Tree 1   08/18/2016 09:56:00 AM 13 Width 0ft   5991332.89244 2095658.50101 37.7337806755214 -122.47237864866 (37.7337806755214, -122.47237864866) 1 8 4 64 40
131012 207124 1 47 2 Cranleigh Dr 5 Front Yard : Yard Tree 1   08/18/2016 09:54:00 AM 9 Width 0ft   5991335.55729 2095661.67857 37.7337895545331 -122.472369667134 (37.7337895545331, -122.472369667134) 1 8 4 64 40
13504 207123 1 47 2 Cranleigh Dr 6 Front Yard : Yard Tree 1   08/18/2016 09:51:00 AM 21 Width 0ft   5991338.6165 2095665.48618 37.7338001863266 -122.472359368113 (37.7338001863266, -122.472359368113) 1 8 4 64 40
162214 207122 1 47 2 Cranleigh Dr 7 Front Yard : Yard Tree 2     12 Width 0ft   5991343.33969 2095670.4637 37.7338141267018 -122.472343401524 (37.7338141267018, -122.472343401524) 1 8 4 64 40
83580 207121 1 47 2 Cranleigh Dr 8 Front Yard : Yard Tree 2     20 Width 0ft   5991346.9817 2095677.27593 37.7338330421511 -122.472331306559 (37.7338330421511, -122.472331306559) 1 8 4 64 40
126406 207120 1 47 2 Cranleigh Dr 9 Front Yard : Yard Tree 2     21 Width 0ft   5991349.86178 2095682.72956 37.7338481831293 -122.472321746778 (37.7338481831293, -122.472321746778) 1 8 4 64 40
157961 207119 1 47 2 Cranleigh Dr 10 Front Yard : Yard Tree 2     25 Width 0ft   5991353.65823 2095688.25461 37.7338635732432 -122.472309024061 (37.7338635732432, -122.472309024061) 1 8 4 64 40
78917 207118 1 47 2 Cranleigh Dr 12 Front Yard : Yard Tree 2     27 Width 0ft   5991361.11034 2095702.06647 37.7339019284143 -122.472284266614 (37.7339019284143, -122.472284266614) 1 8 4 64 40
156310 227675 1 47 1000 San Jose Ave 104 Front Yard : Yard Tree 2     27     6005040.40727 2096975.56438 37.7381808604543 -122.425081325568 (37.7381808604543, -122.425081325568) 2 7 5 63 7
121679 227674 1 47 1000 San Jose Ave 83 Front Yard : Yard Tree 2     15     6005065.10158 2097012.05309 37.7382824451638 -122.424998540269 (37.7382824451638, -122.424998540269) 2 7 5 63 7
181040 227673 1 47 1000 San Jose Ave 64 Front Yard : Yard Tree 2     12     6005078.09924 2097049.53511 37.7383860965292 -122.424956266738 (37.7383860965292, -122.424956266738) 2 7 5 63 7
141197 227672 1 47 1000 San Jose Ave 62 Front Yard : Yard Tree 2     15     6005095.2123 2097053.48648 37.7383979127325 -122.424897379118 (37.7383979127325, -122.424897379118) 2 7 5 28859 7
118985 227671 1 47 1000 San Jose Ave 60 Front Yard : Yard Tree 2     10     6005087.18528 2097058.71456 37.7384118144577 -122.424925504521 (37.7384118144577, -122.424925504521) 2 7 5 63 7
135665 191404 1 47 2 Tulare St 14 Front Yard : Yard Tree 2     20     6016173.59275 2100299.3088 37.7479298037296 -122.3868196817 (37.7479298037296, -122.3868196817)   3 8 58 1
44818 191405 1 47 2 Tulare St 9 Front Yard : Yard Tree 2     8     6016216.75475 2100305.37684 37.7479488549636 -122.386670851103 (37.7479488549636, -122.386670851103)   3 8 58 1
173115 191406 1 47 2 Tulare St 8 Front Yard : Yard Tree 2     5     6016222.17813 2100305.95006 37.7479507291578 -122.386652137081 (37.7479507291578, -122.386652137081)   3 8 58 1
2126 191407 1 47 2 Tulare St 7 Front Yard : Yard Tree 2     12     6016225.71134 2100306.15132 37.747951477381 -122.386639933312 (37.747951477381, -122.386639933312)   3 8 58 1
99467 191408 1 47 2 Tulare St 5 Front Yard : Yard Tree 2     3     6016232.34971 2100308.61772 37.7479586171136 -122.38661714986 (37.7479586171136, -122.38661714986)   3 8 58 1
58452 101254 1 47 3700X Cesar Chavez St 1 Front Yard : Yard Tree 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
181779 191403 1 47 2100 Alameda St 9 Front Yard : Yard Tree 2     5     6010692.20162 2107913.0668 37.7685304704432 -122.406310559796 (37.7685304704432, -122.406310559796) 8 4 8 28853 19
10441 191402 1 47 2100 Alameda St 8 Front Yard : Yard Tree 2     7     6010700.42675 2107913.45144 37.7685319866755 -122.406282136733 (37.7685319866755, -122.406282136733) 8 4 8 28853 19
53776 191401 1 47 2100 Alameda St 7 Front Yard : Yard Tree 2     8     6010711.19096 2107913.74245 37.7685333878424 -122.406244924566 (37.7685333878424, -122.406244924566) 8 4 8 28853 19
56934 191400 1 47 2100 Alameda St 6 Front Yard : Yard Tree 2     18     6010721.65743 2107914.21049 37.7685352584272 -122.406208754734 (37.7685352584272, -122.406208754734) 8 4 8 28853 19
154411 191399 1 47 2100 Alameda St 5 Front Yard : Yard Tree 2     5     6010727.66479 2107914.72417 37.7685370048986 -122.406188011877 (37.7685370048986, -122.406188011877) 8 4 8 28853 19
113892 191398 1 47 2100 Alameda St 4 Front Yard : Yard Tree 2     14     6010740.07849 2107915.77093 37.7685405734149 -122.406145147482 (37.7685405734149, -122.406145147482) 8 4 8 28853 19
16955 191397 1 47 2100 Alameda St 3 Front Yard : Yard Tree 2     9     6010751.13717 2107916.66974 37.768543659889 -122.406106959582 (37.768543659889, -122.406106959582) 8 4 8 28853 19
66446 191396 1 47 2100 Alameda St 2 Front Yard : Yard Tree 2     6     6010761.04996 2107917.30957 37.7685459711594 -122.406072716988 (37.7685459711594, -122.406072716988) 8 4 8 28853 19
179306 191395 1 47 2100 Alameda St 1 Front Yard : Yard Tree 2     22     6010771.29847 2107917.19939 37.7685462418407 -122.406037260315 (37.7685462418407, -122.406037260315) 8 4 8 28853 19
174774 249938 1 47 339 Filbert St 3 Front Yard : Yard Tree 2     8 Width 0ft   6011244.68883 2120032.52194 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256) 3 1 10 308 23