trees
858 rows where qSpecies_id = 85 sorted by Longitude
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30083 | 201521 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 869 Innes Ave | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6019420.24762 | 2094273.01088 | 37.7315619976776 | -122.375175152832 | (37.7315619976776, -122.375175152832) | 10 | 3 | 8 | 58 | 1 | |||
6527 | 40000 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.02926 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | 10 | 3 | 8 | 58 | 1 | |
64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
74104 | 40001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | 10 | 3 | 8 | 58 | 1 | |
46103 | 39999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.7317008637943 | -122.375429242788 | (37.7317008637943, -122.375429242788) | 10 | 3 | 8 | 58 | 1 | |
20782 | 40002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | 10 | 3 | 8 | 58 | 1 | |
28707 | 50621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | 10 | 3 | 8 | 58 | 1 | |||
86009 | 40007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.61704 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | 10 | 3 | 8 | 58 | 1 | |
101290 | 69866 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52372 | 6018792.25966014 | 2094248.90737336 | 37.7314612388187 | -122.377344581888 | (37.7314612388187, -122.377344581888) | 10 | 3 | 8 | 58 | 1 | ||
43497 | 197813 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015877.12645 | 2095949.17922 | 37.7359688205142 | -122.387541417306 | (37.7359688205142, -122.387541417306) | 10 | 3 | 8 | 58 | 1 | |||
11327 | 12222 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1543 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6015840.7459 | 2095893.0455 | 37.7358126735457 | -122.387663285334 | (37.7358126735457, -122.387663285334) | 10 | 3 | 8 | 58 | 1 | ||
25201 | 199699 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2098 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015522.8982 | 2092787.4061 | 37.7272675999797 | -122.388545507017 | (37.7272675999797, -122.388545507017) | 10 | 3 | 8 | 58 | 1 | |||
100870 | 54823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1438 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10677 | 6015466.1212 | 2093109.3415 | 37.7281484238722 | -122.388764251275 | (37.7281484238722, -122.388764251275) | 10 | 3 | 8 | 58 | 1 | ||
129927 | 199676 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1438 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015463.3731 | 2093112.0896 | 37.7281558172955 | -122.388773943405 | (37.7281558172955, -122.388773943405) | 10 | 3 | 8 | 58 | 1 | |||
22473 | 37940 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | 10 | 3 | 8 | 28856 | 29 | |
159511 | 59235 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 730 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 16 | Permit Number 31141 | 6015660.35324 | 2103965.97001 | 37.7579692531876 | -122.388850400349 | (37.7579692531876, -122.388850400349) | 10 | 3 | 8 | 28856 | 29 | |
52850 | 197768 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 15 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | 10 | 3 | 8 | 28856 | 29 | |||
184695 | 197766 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 13 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6015570.19786 | 2103483.29331 | 37.756638928352 | -122.389128496797 | (37.756638928352, -122.389128496797) | 10 | 3 | 8 | 28856 | 29 | |||
36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
137880 | 197765 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 11 | Median : Yard | Tree | DPW 1 | 12 | Width 8ft | 6015567.05153 | 2103517.02147 | 37.756731364291 | -122.389141732999 | (37.756731364291, -122.389141732999) | 10 | 3 | 8 | 28856 | 29 | |||
17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
191400 | 197770 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 6015491.65418 | 2103907.18258 | 37.7577984836214 | -122.389429732797 | (37.7577984836214, -122.389429732797) | 10 | 3 | 8 | 28856 | 29 | |||
53030 | 60578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20192 | 6015478.27896 | 2103906.06329 | 37.7577946687129 | -122.389475912095 | (37.7577946687129, -122.389475912095) | 10 | 3 | 8 | 28856 | 29 | ||
70738 | 197763 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1405 Minnesota St | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | 10 | 3 | 8 | 28856 | 1 | ||||
100832 | 197769 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1301 Minnesota St | 54 | Front Yard : Yard | Tree | Private 2 | 7 | 6015357.64937 | 2102415.32545 | 37.7536947305524 | -122.389788979575 | (37.7536947305524, -122.389788979575) | 10 | 3 | 8 | 28856 | 29 | ||||
155684 | 96661 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2012 12:00:00 AM | 6 | 3x3 | 6015012.1415 | 2095435.3006 | 37.7345098664919 | -122.390496145326 | (37.7345098664919, -122.390496145326) | 10 | 3 | 8 | 58 | 1 | ||
127108 | 96662 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015000.5996 | 2095419.9114 | 37.7344669705832 | -122.390534974863 | (37.7344669705832, -122.390534974863) | 10 | 3 | 8 | 58 | 1 | |||
72093 | 96663 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6014978.6151 | 2095394.6292 | 37.7343963311622 | -122.390609217071 | (37.7343963311622, -122.390609217071) | 10 | 3 | 8 | 58 | 1 | |||
17510 | 70565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014527.51657 | 2111489.70716 | 37.7785649223813 | -122.39329474466 | (37.7785649223813, -122.39329474466) | 6 | 2 | 9 | 28856 | 34 | |||
129371 | 50009 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.76129 | 2105171.60414 | 37.7612048790107 | -122.393595359241 | (37.7612048790107, -122.393595359241) | 10 | 3 | 8 | 28856 | 29 |
58437 | 50007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.7489 | 2105179.47261 | 37.7612264834299 | -122.393595952812 | (37.7612264834299, -122.393595952812) | 10 | 3 | 8 | 28856 | 29 |
15296 | 49997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.2211 | 2105187.35151 | 37.7612480878485 | -122.393598329713 | (37.7612480878485, -122.393598329713) | 10 | 3 | 8 | 28856 | 29 |
41124 | 50008 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014311.55635 | 2105196.94353 | 37.7612743885122 | -122.393601300174 | (37.7612743885122, -122.393601300174) | 10 | 3 | 8 | 28856 | 29 |
193137 | 197771 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 398 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014310.79788 | 2105214.47052 | 37.7613224716698 | -122.393605150155 | (37.7613224716698, -122.393605150155) | 10 | 3 | 8 | 28856 | 29 | |||
137182 | 50003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 11 | 0 | Permit Number 46740 | 6014266.61344 | 2105244.3143 | 37.7614019609488 | -122.393760055695 | (37.7614019609488, -122.393760055695) | 10 | 3 | 8 | 28856 | 29 |
104595 | 50002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.7614007945303 | -122.393790293612 | (37.7614007945303, -122.393790293612) | 10 | 3 | 8 | 28856 | 29 |
108105 | 49999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014232.027 | 2105242.25356 | 37.7613943805613 | -122.393879532433 | (37.7613943805613, -122.393879532433) | 10 | 3 | 8 | 28856 | 29 |
14932 | 51370 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 39 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 47705 | 6013932.28471 | 2095479.44374 | 37.7345711103726 | -122.394232686294 | (37.7345711103726, -122.394232686294) | 10 | 3 | 8 | 58 | 1 |
109530 | 34193 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 353 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 11 | Permit Number 38012 | 6014082.04806 | 2105345.22896 | 37.7616687924926 | -122.394405461342 | (37.7616687924926, -122.394405461342) | 10 | 3 | 8 | 28856 | 29 | ||
68536 | 197793 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 66 Ceres St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | 10 | 3 | 8 | 58 | 1 | |||
182374 | 197794 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 74 Ceres St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6013828.41074 | 2093793.76095 | 37.7299367959446 | -122.394473821531 | (37.7299367959446, -122.394473821531) | 10 | 3 | 8 | 58 | 1 | |||
99768 | 197789 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 519 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013841.50507 | 2104663.54923 | 37.7597836741058 | -122.395189656687 | (37.7597836741058, -122.395189656687) | 10 | 3 | 8 | 28856 | 29 | |||
20212 | 197797 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 315 Topeka Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6013586.21958 | 2094425.53729 | 37.731658057859 | -122.395355352274 | (37.731658057859, -122.395355352274) | 10 | 3 | 8 | 58 | 1 | |||
164505 | 53515 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 444 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1969 12:00:00 AM | 15 | Permit Number 6427 | 6013881.11838 | 2111746.93832 | 37.7792352878243 | -122.395548925964 | (37.7792352878243, -122.395548925964) | 6 | 2 | 9 | 28856 | 34 | ||
44332 | 197798 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 444 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013857.66162 | 2111727.99067 | 37.7791819571277 | -122.395628745281 | (37.7791819571277, -122.395628745281) | 6 | 2 | 9 | 28856 | 34 | |||
91407 | 197812 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 958 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6013362.44746 | 2089433.04688 | 37.7179372398964 | -122.395779290899 | (37.7179372398964, -122.395779290899) | 10 | 3 | 8 | 58 | 1 | |||
63418 | 43902 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2000 12:00:00 AM | 11 | Permit Number 43504 | 6013487.64027 | 2095982.13361 | 37.735926667475 | -122.395805194058 | (37.735926667475, -122.395805194058) | 10 | 3 | 8 | 58 | 1 | ||
80390 | 197795 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013476.07087 | 2095990.32103 | 37.735948504815 | -122.395845767893 | (37.735948504815, -122.395845767893) | 10 | 3 | 8 | 58 | 1 | |||
35261 | 197796 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6013463.04553 | 2095982.9565 | 37.7359275587079 | -122.395890286113 | (37.7359275587079, -122.395890286113) | 10 | 3 | 8 | 58 | 1 | |||
39646 | 93672 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 80 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53291 | 6013405 | 2106710 | 37.7653784929972 | -122.396842798823 | (37.7653784929972, -122.396842798823) | 14 | 3 | 8 | 28856 | 20 | |||
31445 | 197792 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 228 Connecticut St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6013148.35308 | 2105968.0458 | 37.7633269624894 | -122.397678442332 | (37.7633269624894, -122.397678442332) | 14 | 3 | 8 | 28856 | 29 | |||
138463 | 89357 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 228 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51938 | 6013147.53737 | 2105984.72439 | 37.7633727127903 | -122.397682433524 | (37.7633727127903, -122.397682433524) | 14 | 3 | 8 | 28856 | 29 | |
179124 | 179579 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012735.13686 | 2087513.11495 | 37.71263057163 | -122.397813044753 | (37.71263057163, -122.397813044753) | 10 | 3 | 8 | 309 | 1 | |||
113645 | 179580 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012727.00999 | 2087491.1806 | 37.7125698916572 | -122.397839596325 | (37.7125698916572, -122.397839596325) | 10 | 3 | 8 | 309 | 1 | |||
144993 | 54942 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 238 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 12 | Permit Number 10820 | 6012686.68001 | 2087364.92959 | 37.7122209852769 | -122.397970139226 | (37.7122209852769, -122.397970139226) | 10 | 3 | 8 | 309 | 1 | ||
2442 | 35339 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 740 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 9 | Permit Number 38804 | 6013014.621 | 2103534.39703 | 37.7566372493387 | -122.397970249845 | (37.7566372493387, -122.397970249845) | 10 | 3 | 8 | 28856 | 29 | |
79884 | 179581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 238 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012679.41908 | 2087343.61539 | 37.7121620563027 | -122.397993741039 | (37.7121620563027, -122.397993741039) | 10 | 3 | 8 | 309 | 1 | |||
30055 | 197791 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | 10 | 3 | 8 | 28856 | 29 | |||
53726 | 197790 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.48867 | 2105422.76056 | 37.7618158127736 | -122.398504382391 | (37.7618158127736, -122.398504382391) | 10 | 3 | 8 | 28856 | 29 | |||
119998 | 197778 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Wisconsin St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012724.98358 | 2104673.0292 | 37.7597475483381 | -122.399051845593 | (37.7597475483381, -122.399051845593) | 10 | 3 | 8 | 28856 | 29 | |||
134778 | 104026 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 782 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012702.6895 | 2103864.81876 | 37.7575271374861 | -122.399072220626 | (37.7575271374861, -122.399072220626) | 10 | 3 | 8 | 28856 | 29 | |||
164153 | 197784 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1695 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012642.35451 | 2105617.14679 | 37.7623352818773 | -122.399403901394 | (37.7623352818773, -122.399403901394) | 10 | 3 | 8 | 28856 | 29 | |||
190305 | 51716 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 15 | Permit Number 47987 | 6012715.82138 | 2110122.77746 | 37.7747108273731 | -122.399466139876 | (37.7747108273731, -122.399466139876) | 14 | 2 | 9 | 28856 | 20 | ||
78679 | 197783 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1695 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012618.01326 | 2105616.47326 | 37.7623320757988 | -122.399488041942 | (37.7623320757988, -122.399488041942) | 10 | 3 | 8 | 28856 | 29 | |||
65482 | 197777 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012626.2473 | 2106084.84783 | 37.7636185874431 | -122.399492447726 | (37.7636185874431, -122.399492447726) | 14 | 3 | 8 | 28856 | 29 | |||
11004 | 51713 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.7746518507372 | -122.399541492249 | (37.7746518507372, -122.399541492249) | 14 | 2 | 9 | 28856 | 20 | ||
171312 | 179582 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 299 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012218.08468 | 2086837.71527 | 37.7107472500657 | -122.399552761654 | (37.7107472500657, -122.399552761654) | 10 | 3 | 8 | 309 | 1 | |||
46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
127738 | 51712 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
18467 | 51710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.7745917067712 | -122.399616105424 | (37.7745917067712, -122.399616105424) | 14 | 2 | 9 | 28856 | 20 | ||
53857 | 197776 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012588.49637 | 2106082.79155 | 37.7636108370988 | -122.399622872805 | (37.7636108370988, -122.399622872805) | 14 | 3 | 8 | 28856 | 29 | |||
34667 | 197775 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012572.98246 | 2106081.16458 | 37.7636055050056 | -122.399676416648 | (37.7636055050056, -122.399676416648) | 14 | 3 | 8 | 28856 | 29 | |||
23586 | 51714 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 14 | Permit Number 47987 | 6012645.95948 | 2110058.2702 | 37.7745298109235 | -122.399703277606 | (37.7745298109235, -122.399703277606) | 14 | 2 | 9 | 28856 | 20 | ||
27810 | 179583 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 299 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012138.53838 | 2086862.1031 | 37.7108097799129 | -122.399829404828 | (37.7108097799129, -122.399829404828) | 10 | 3 | 8 | 309 | 1 | |||
33843 | 51717 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.85826 | 37.7743943397653 | -122.399857674991 | (37.7743943397653, -122.399857674991) | 14 | 2 | 9 | 28856 | 20 | ||
111165 | 197774 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1601 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012501.40627 | 2106077.71632 | 37.7635920466475 | -122.399923735603 | (37.7635920466475, -122.399923735603) | 14 | 3 | 8 | 28856 | 29 | |||
39190 | 41631 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.399940414441 | (37.7743312765925, -122.399940414441) | 14 | 2 | 9 | 28856 | 20 | ||
54508 | 197773 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1601 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012487.36348 | 2106076.40737 | 37.7635876696487 | -122.399972213573 | (37.7635876696487, -122.399972213573) | 14 | 3 | 8 | 28856 | 29 | |||
165484 | 197799 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 633 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6012559.41823 | 2109925.01759 | 37.7741591049858 | -122.399993282875 | (37.7741591049858, -122.399993282875) | 14 | 2 | 9 | 28856 | 20 | |||
19979 | 41630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.7742530301757 | -122.400029064208 | (37.7742530301757, -122.400029064208) | 14 | 2 | 9 | 28856 | 20 | ||
123546 | 197800 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 633 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012543.89196 | 2109939.0367 | 37.774196732621 | -122.400047976054 | (37.774196732621, -122.400047976054) | 14 | 2 | 9 | 28856 | 20 | |||
16751 | 78587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012314.29117 | 2102093.10716 | 37.7526407529845 | -122.400291031321 | (37.7526407529845, -122.400291031321) | 10 | 3 | 8 | 28856 | 29 | |||
89282 | 197786 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1361 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012312.79275 | 2102115.82451 | 37.7527030463337 | -122.400297808599 | (37.7527030463337, -122.400297808599) | 10 | 3 | 8 | 28856 | 29 | |||
147824 | 197780 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6012306.16888 | 2105129.4527 | 37.7609774386872 | -122.40053238957 | (37.7609774386872, -122.40053238957) | 10 | 3 | 8 | 28856 | 29 | |||
125078 | 197779 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012297.04253 | 2105129.1602 | 37.7609761265741 | -122.400563933278 | (37.7609761265741, -122.400563933278) | 10 | 3 | 8 | 28856 | 29 | |||
48581 | 121492 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6012288.86366 | 2105128.25072 | 37.760973173204 | -122.400592156703 | (37.760973173204, -122.400592156703) | 10 | 3 | 8 | 28856 | 29 | ||||
82759 | 35347 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.7553677771151 | -122.400595641589 | (37.7553677771151, -122.400595641589) | 10 | 3 | 8 | 28856 | 29 | |
171181 | 197787 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2224 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012129.32892 | 2101895.6849 | 37.7520883587965 | -122.400916797591 | (37.7520883587965, -122.400916797591) | 10 | 3 | 8 | 28856 | 29 | |||
90512 | 187427 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3199 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6011854.6582 | 2090886.7407 | 37.7218447944319 | -122.40109317658 | (37.7218447944319, -122.40109317658) | 10 | 3 | 7 | 309 | 28 | |||
129906 | 40630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2130 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2005 12:00:00 AM | 16 | Permit Number 48121 | 6012083.9226 | 2102367.98712 | 37.7533826648878 | -122.401107004196 | (37.7533826648878, -122.401107004196) | 10 | 3 | 8 | 28856 | 29 | |
114532 | 24893 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3195 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 18 | 2X3 | 6011845.1957 | 2090907.7685 | 37.7219020046048 | -122.401127363027 | (37.7219020046048, -122.401127363027) | 10 | 3 | 7 | 309 | 28 | ||
111943 | 24916 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3180 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 16 | 2X3 | 6011786.8435 | 2090915.654 | 37.7219204011149 | -122.401329626814 | (37.7219204011149, -122.401329626814) | 10 | 3 | 7 | 309 | 28 | ||
88530 | 24912 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3106 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 16 | 2X3 | 6011710.6178 | 2091173.2445 | 37.7226234388506 | -122.401611216966 | (37.7226234388506, -122.401611216966) | 10 | 3 | 7 | 309 | 28 | ||
120953 | 28672 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3100 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011704.8351 | 2091194.798 | 37.7226822976708 | -122.401632720761 | (37.7226822976708, -122.401632720761) | 10 | 3 | 7 | 309 | 28 | ||
33501 | 197788 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2056 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011954.13771 | 2104694.98029 | 37.7597648350875 | -122.401719379549 | (37.7597648350875, -122.401719379549) | 10 | 3 | 8 | 28856 | 29 | |||
134210 | 197772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 370 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011991.34418 | 2106649.17126 | 37.7651326842421 | -122.401728059814 | (37.7651326842421, -122.401728059814) | 8 | 3 | 8 | 28853 | 20 | |||
96742 | 58378 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1020 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2013 12:00:00 AM | 4 | Permit Number 769968 | 6011874.40937 | 2103617.93894 | 37.7568030681131 | -122.401919409461 | (37.7568030681131, -122.401919409461) | 10 | 3 | 8 | 28856 | 29 | ||
58846 | 51534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 10 | Permit Number 47835 | 6012007.91318 | 2110835.16017 | 37.7766273842858 | -122.401965041949 | (37.7766273842858, -122.401965041949) | 14 | 2 | 9 | 28856 | 34 | ||
16391 | 197750 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6012005.03317 | 2110833.59776 | 37.7766229335303 | -122.401974894942 | (37.7766229335303, -122.401974894942) | 14 | 2 | 9 | 28856 | 34 | |||
76354 | 28703 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011599.0463446 | 2091533.093888 | 37.7236052850781 | -122.402022182135 | (37.7236052850781, -122.402022182135) | 10 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );