trees
723 rows where qLegalStatus_id = 1 and qSpecies_id = 65 sorted by DBH
This data as json, CSV (advanced)
These facets timed out: qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1157 | 115169 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1463 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777351 | 5983676.8 | 2105200 | 37.759532920891 | -122.499552539829 | (37.759532920891, -122.499552539829) | 1 | 8 | 3 | 56 | 35 | |||
2188 | 260529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1814 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5982887.98375 | 2102765.67441 | 37.7528026329038 | -122.502100475367 | (37.7528026329038, -122.502100475367) | 1 | 8 | 3 | 56 | 35 | ||||
3053 | 262433 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 470 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3x3 | 6001714 | 2091050 | 37.7217221467453 | -122.43615844491 | (37.7217221467453, -122.43615844491) | 9 | 7 | 6 | 28861 | 5 | |||
5467 | 261155 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2119 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3x3 | 5983519 | 2100707 | 37.7471871347586 | -122.499766192027 | (37.7471871347586, -122.499766192027) | 1 | 8 | 3 | 29491 | 35 | |||
6228 | 261512 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 811 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:00:00 AM | Width 3ft | 5985072.23291 | 2110298.05819 | 37.7736125294233 | -122.495102444732 | (37.7736125294233, -122.495102444732) | 11 | 6 | 2 | 55 | 26 | |||
11799 | 261147 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3220x Santiago St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982825 | 2099474 | 37.7437609086011 | -122.502074725774 | (37.7437609086011, -122.502074725774) | 1 | 8 | 3 | 29491 | 35 | |||
12483 | 261152 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2279 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982935 | 2099631 | 37.7441984490884 | -122.501705991239 | (37.7441984490884, -122.501705991239) | 1 | 8 | 3 | 29491 | 35 | |||
12905 | 261154 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2246 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982704 | 2099822 | 37.7447093112365 | -122.502518859637 | (37.7447093112365, -122.502518859637) | 1 | 8 | 3 | 29491 | 35 | |||
13131 | 261138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2600 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5984799 | 2099596 | 37.7442116594147 | -122.4952581999 | (37.7442116594147, -122.4952581999) | 1 | 8 | 3 | 29491 | 35 | ||||
14927 | 262428 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||||
15772 | 261153 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2291 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982938 | 2099557 | 37.7439954416833 | -122.501690144388 | (37.7439954416833, -122.501690144388) | 1 | 8 | 3 | 29491 | 35 | |||
17368 | 261151 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2107 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 5982896 | 2100761 | 37.7472988260012 | -122.501924436785 | (37.7472988260012, -122.501924436785) | 1 | 8 | 3 | 29491 | 35 | |||
29277 | 256167 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
64228 | 114566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | 11 | 6 | 1 | 54 | 31 | |||
78891 | 115281 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2320 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774954 | 5988790.4 | 2098360 | 37.7410508098993 | -122.481366468975 | (37.7410508098993, -122.481366468975) | 1 | 8 | 3 | 29491 | 35 | |||
90019 | 115171 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2218 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 774487 | 5982698.2 | 2099998.9 | 37.7451946889287 | -122.502552005341 | (37.7451946889287, -122.502552005341) | 1 | 8 | 3 | 29491 | 35 | |||
111638 | 115173 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2063 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775267 | 5982265.3 | 2101066.7 | 37.7481011229623 | -122.504127955016 | (37.7481011229623, -122.504127955016) | 1 | 8 | 3 | 29491 | 35 | |||
114233 | 114349 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798 | (37.7634027199113, -122.50597849798) | 1 | 8 | 3 | 56 | 35 | ||
116231 | 114809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.484804508138 | (37.763791122625, -122.484804508138) | 1 | 8 | 3 | 56 | 35 | |||
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
123393 | 115172 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | 1 | 8 | 3 | 56 | 35 | |||
172187 | 114784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.442797219915 | (37.7837071608561, -122.442797219915) | 15 | 6 | 1 | 29490 | 13 | |||
172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
185139 | 114957 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770549 | 5993817 | 2111494.4 | 37.7774054340765 | -122.46494011266 | (37.7774054340765, -122.46494011266) | 11 | 6 | 2 | 54 | 11 | |||
189079 | 253703 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2105574 | 37.7614443133046 | -122.446746977382 | (37.7614443133046, -122.446746977382) | 15 | 5 | 11 | 29492 | 12 | ||||
652 | 144195 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 630 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:17:00 PM | 0 | Width 4ft | 5982905.71974 | 2111464.01201 | 37.7766868258595 | -122.502682939079 | (37.7766868258595, -122.502682939079) | 11 | 6 | 2 | 55 | 26 | ||
730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
6851 | 144169 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 638 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 11:23:00 AM | 0 | Width 4ft | 5983217.80995 | 2111442.38703 | 37.7766457853136 | -122.501601744449 | (37.7766457853136, -122.501601744449) | 11 | 6 | 2 | 55 | 26 | ||
9080 | 160643 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 556 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001401.85862 | 2090517.84189 | 37.7202432212254 | -122.437199350171 | (37.7202432212254, -122.437199350171) | 9 | 7 | 6 | 28861 | 5 | ||
13145 | 144156 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 750 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:08:00 PM | 0 | Width 4ft | 5983244.96709 | 2110688.35529 | 37.774577028035 | -122.501452009119 | (37.774577028035, -122.501452009119) | 11 | 6 | 2 | 55 | 26 | ||
16050 | 144227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 782 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:48:00 PM | 0 | Width 4ft | 5982631.55426 | 2110466.9997 | 37.7739332051856 | -122.503557493782 | (37.7739332051856, -122.503557493782) | 11 | 6 | 2 | 55 | 26 | ||
19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
145878 | 100940 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1470 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2012 12:00:00 AM | 0 | Permit Number 769322 | 5982213.5 | 2105098.8 | 37.7591690876422 | -122.504605773131 | (37.7591690876422, -122.504605773131) | 1 | 8 | 3 | 56 | 35 | ||
138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
1710 | 51499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983157 | 2104773 | 37.758329986723 | -122.501318651686 | (37.758329986723, -122.501318651686) | 1 | 8 | 3 | 56 | 35 | ||
3963 | 203515 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993048.57106 | 2102513.42561 | 37.7527017117304 | -122.466945265911 | (37.7527017117304, -122.466945265911) | 1 | 8 | 4 | 29491 | 12 | |||
5498 | 183675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1274 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984003.8455 | 2106504.9034 | 37.7631350020634 | -122.498517860637 | (37.7631350020634, -122.498517860637) | 1 | 8 | 3 | 56 | 35 | |||
7243 | 203528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992568.77798 | 2096730.41145 | 37.7367953253409 | -122.46818381133 | (37.7367953253409, -122.46818381133) | 1 | 8 | 4 | 59 | 40 | |||
11272 | 221805 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003874.14486 | 2100377.76702 | 37.7474565750744 | -122.429356224108 | (37.7474565750744, -122.429356224108) | 2 | 7 | 5 | 63 | 22 | |||
16596 | 203511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992377.24702 | 2106218.29367 | 37.7628355396396 | -122.469536476251 | (37.7628355396396, -122.469536476251) | 1 | 8 | 11 | 56 | 12 | |||
19773 | 113547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | 10 | 3 | 8 | 28856 | 29 | ||
34536 | 221809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.7629228845101 | -122.449307297897 | (37.7629228845101, -122.449307297897) | 15 | 5 | 11 | 29492 | 9 | |||
35299 | 203521 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991886.81261 | 2104359.60659 | 37.757703719373 | -122.471097283818 | (37.757703719373, -122.471097283818) | 1 | 8 | 4 | 56 | 12 | |||
40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 | |||
62410 | 203526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2424 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.19197 | 2098908.13909 | 37.7427450799172 | -122.470121471754 | (37.7427450799172, -122.470121471754) | 1 | 8 | 4 | 29491 | 40 | |||
64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 2 | 7 | 7 | 28859 | 2 | |||
65106 | 175181 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002921.15596 | 2089379.53862 | 37.7172039398928 | -122.431866410902 | (37.7172039398928, -122.431866410902) | 9 | 7 | 6 | 28861 | 5 | |||
67282 | 203548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999484.36005 | 2094058.99303 | 37.7298572167403 | -122.444081798854 | (37.7298572167403, -122.444081798854) | 9 | 7 | 4 | 63 | 40 | |||
69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
72775 | 125543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 511 Webster St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | 7 | 9 | 11 | 29492 | 10 | |||
73816 | 203517 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993021.77901 | 2102511.9902 | 37.7526962240514 | -122.467037812458 | (37.7526962240514, -122.467037812458) | 1 | 8 | 4 | 29491 | 12 | |||
73986 | 221859 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 861 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000847.19345 | 2101982.10251 | 37.7516898602076 | -122.439938212095 | (37.7516898602076, -122.439938212095) | 2 | 4 | 5 | 28862 | 22 | |||
75795 | 118877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5981379.17338 | 2110733.6758 | 37.7745917102455 | -122.507909405784 | (37.7745917102455, -122.507909405784) | 11 | 6 | 2 | 55 | 26 | |||
76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
77602 | 203529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992569.96638 | 2096706.93709 | 37.7367309392805 | -122.468177995418 | (37.7367309392805, -122.468177995418) | 1 | 8 | 4 | 59 | 40 | |||
80295 | 175183 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003446.11855 | 2091231.22966 | 37.7223180210418 | -122.430183890869 | (37.7223180210418, -122.430183890869) | 9 | 7 | 6 | 28861 | 5 | |||
87919 | 221912 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 424 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003582.26596 | 2102758.00468 | 37.7539756202844 | -122.43053533425 | (37.7539756202844, -122.43053533425) | 2 | 4 | 5 | 28862 | 22 | |||
88463 | 251005 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 342 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981698.04635 | 2112709.85802 | 37.7800365073085 | -122.506953000187 | (37.7800365073085, -122.506953000187) | 11 | 6 | 2 | 55 | 26 | |||
90849 | 221932 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001846.56535 | 2107325.41516 | 37.7664181410013 | -122.436864736716 | (37.7664181410013, -122.436864736716) | 15 | 5 | 5 | 28862 | 3 | |||
101049 | 203522 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 62 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991862.2088 | 2104389.33207 | 37.7577839146257 | -122.471184538744 | (37.7577839146257, -122.471184538744) | 1 | 8 | 4 | 56 | 12 | |||
103782 | 221810 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998223.78162 | 2106145.07477 | 37.7629706574012 | -122.449310175733 | (37.7629706574012, -122.449310175733) | 15 | 5 | 11 | 29492 | 9 | |||
106840 | 82673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.29338 | 2089198.31583 | 37.7172681083272 | -122.397291182543 | (37.7172681083272, -122.397291182543) | 10 | 3 | 8 | 58 | 1 | |
108759 | 175185 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 526 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012801.34824 | 2086611.11374 | 37.7101575412033 | -122.397520974627 | (37.7101575412033, -122.397520974627) | 10 | 3 | 8 | 309 | 1 | |||
115143 | 221806 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.7474184051535 | -122.429351626769 | (37.7474184051535, -122.429351626769) | 2 | 7 | 5 | 63 | 22 | |||
115309 | 203525 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.69549 | 2098894.88306 | 37.74270871135 | -122.470118765694 | (37.74270871135, -122.470118765694) | 1 | 8 | 4 | 29491 | 40 | |||
118838 | 203560 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.7168443846497 | -122.451802840126 | (37.7168443846497, -122.451802840126) | 9 | 8 | 6 | 28861 | 24 | |||
126749 | 175180 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002933.07108 | 2089399.59548 | 37.7172596870602 | -122.43182665728 | (37.7172596870602, -122.43182665728) | 9 | 7 | 6 | 28861 | 5 | |||
128312 | 221938 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002640.28984 | 2096352.56391 | 37.7363343706279 | -122.433335224139 | (37.7363343706279, -122.433335224139) | 2 | 7 | 5 | 63 | 7 | |||
136814 | 184696 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1616 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982844.9615 | 2104111.9169 | 37.7564965092336 | -122.502348875623 | (37.7564965092336, -122.502348875623) | 1 | 8 | 3 | 56 | 35 | |||
139226 | 221921 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002945.55902 | 2105503.88006 | 37.7614790472472 | -122.432933374683 | (37.7614790472472, -122.432933374683) | 15 | 4 | 5 | 28862 | 3 | |||
141712 | 125540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001554.26648 | 2121557.3314 | 37.8054787165372 | -122.438895742254 | (37.8054787165372, -122.438895742254) | 13 | 9 | 1 | 57 | 17 | |||
142588 | 203516 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993037.18841 | 2102512.99868 | 37.7526998825032 | -122.466984597774 | (37.7526998825032, -122.466984597774) | 1 | 8 | 4 | 29491 | 12 | |||
143164 | 67951 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 546 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 1 | Permit Number 31666 | 5988462.26619 | 2112267.73562 | 37.7792185950288 | -122.483520377593 | (37.7792185950288, -122.483520377593) | 11 | 6 | 2 | 55 | 26 | |
143333 | 123274 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993793.96487 | 2111482.47797 | 37.7773713711806 | -122.465018932008 | (37.7773713711806, -122.465018932008) | 11 | 6 | 2 | 54 | 11 | |||
146558 | 117937 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 852 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5982958.99767 | 2109991.00517 | 37.7726455076262 | -122.502389596139 | (37.7726455076262, -122.502389596139) | 11 | 6 | 2 | 55 | 26 | |||
151328 | 203513 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 112 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993653.12973 | 2102595.20165 | 37.7529611229783 | -122.464860549271 | (37.7529611229783, -122.464860549271) | 1 | 8 | 4 | 56 | 12 | |||
159409 | 203518 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 415 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993563.6385 | 2105259.44911 | 37.7602712973034 | -122.465363541894 | (37.7602712973034, -122.465363541894) | 1 | 8 | 4 | 56 | 12 | |||
162352 | 4572 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 233 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 6x6 | Permit Number 775065 | 6006398.09865 | 2098473.12689 | 37.742369434016 | -122.420493366683 | (37.742369434016, -122.420493366683) | 2 | 7 | 7 | 28859 | 2 | |
169336 | 221863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003563.65489 | 2095975.96127 | 37.7353526463955 | -122.430115909332 | (37.7353526463955, -122.430115909332) | 2 | 7 | 5 | 63 | 7 | |||
172010 | 175193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Harrington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002083.86995 | 2092418.47999 | 37.7255006920777 | -122.434977725241 | (37.7255006920777, -122.434977725241) | 9 | 7 | 6 | 28861 | 25 | |||
175320 | 203524 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992056.59882 | 2098873.80652 | 37.7426509505813 | -122.470110650206 | (37.7426509505813, -122.470110650206) | 1 | 8 | 4 | 29491 | 40 | |||
188936 | 113546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.09048 | 2105100.13383 | 37.7608633956443 | -122.402609207467 | (37.7608633956443, -122.402609207467) | 10 | 3 | 8 | 28856 | 29 | ||
8943 | 73896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004393.10182 | 2091444.69797 | 37.7229577492801 | -122.426925586868 | (37.7229577492801, -122.426925586868) | 9 | 7 | 6 | 28861 | 5 | |||
10220 | 221824 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007730.82531 | 2096150.27006 | 37.7360663969372 | -122.415720751814 | (37.7360663969372, -122.415720751814) | 2 | 7 | 7 | 28859 | 2 | |||
16727 | 227695 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6001245.67427 | 2103366.3123 | 37.7555132424609 | -122.438659390527 | (37.7555132424609, -122.438659390527) | 2 | 4 | 5 | 28862 | 3 | |||
21660 | 65231 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.15348 | 37.7291116131036 | -122.41347586773 | (37.7291116131036, -122.41347586773) | 9 | 3 | 7 | 309 | 28 | ||
21664 | 175212 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 87x Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005258.73549 | 2092540.80848 | 37.7260163372638 | -122.424011175489 | (37.7260163372638, -122.424011175489) | 9 | 7 | 7 | 309 | 5 | |||
35034 | 221861 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004637.65749 | 2096950.59035 | 37.7380895280136 | -122.426472056954 | (37.7380895280136, -122.426472056954) | 2 | 7 | 5 | 63 | 7 | |||
38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
42770 | 221831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 569 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007292.05586 | 2104018.90213 | 37.7576472149557 | -122.417795338504 | (37.7576472149557, -122.417795338504) | 2 | 4 | 7 | 28859 | 19 | |||
46734 | 125549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006015.52243 | 2119649.2025 | 37.8004922923456 | -122.423321211112 | (37.8004922923456, -122.423321211112) | 13 | 9 | 1 | 28858 | 32 | |||
71659 | 221855 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 310 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000611.21677 | 2101947.64163 | 37.7515818030572 | -122.440751776575 | (37.7515818030572, -122.440751776575) | 2 | 4 | 5 | 28862 | 22 | |||
77808 | 104992 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.7412333126477 | -122.505795454359 | (37.7412333126477, -122.505795454359) | 1 | 8 | 3 | 29491 | 35 | |
85330 | 221801 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 378 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003412.45231 | 2099242.88691 | 37.7443143087709 | -122.430871746349 | (37.7443143087709, -122.430871746349) | 2 | 7 | 5 | 63 | 22 | |||
95747 | 221850 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004464.56621 | 2095558.73638 | 37.7342580248697 | -122.426971417216 | (37.7342580248697, -122.426971417216) | 2 | 7 | 5 | 28861 | 25 |
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) );