trees
160 rows where qSpecies_id = 276
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113781 | 187414 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2826 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011327.9119 | 2092421.2442 | 37.7260288260243 | -122.40302189172 | (37.7260288260243, -122.40302189172) | 10 | 3 | 7 | 309 | 28 | |||
114131 | 24897 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3061 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1996 12:00:00 AM | 3 | 3X3 | 6011725.8629 | 2091292.0515 | 37.7229505092559 | -122.401566863762 | (37.7229505092559, -122.401566863762) | 10 | 3 | 7 | 309 | 28 | ||
116602 | 220535 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1699 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006582.93571 | 2099749.37356 | 37.7458841347584 | -122.419944800029 | (37.7458841347584, -122.419944800029) | 2 | 7 | 7 | 28859 | 2 | |||
116873 | 25714 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2737 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1997 12:00:00 AM | 3 | 3X3 | 6011254.5774 | 2092832.6005 | 37.727154229717 | -122.403304330925 | (37.727154229717, -122.403304330925) | 10 | 3 | 7 | 309 | 28 | ||
118891 | 187436 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2626 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6011045.4861 | 2093351.7805 | 37.7285681097411 | -122.404063683198 | (37.7285681097411, -122.404063683198) | 10 | 3 | 7 | 309 | 28 | |||
119606 | 2428 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2879 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2004 12:00:00 AM | 3 | 3X3 | 6009876.65085 | 2100674.50521 | 37.7486093566383 | -122.408620791343 | (37.7486093566383, -122.408620791343) | 2 | 4 | 7 | 28859 | 19 | ||
120171 | 201957 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013560.61826 | 2092421.49888 | 37.7261539524313 | -122.395303527044 | (37.7261539524313, -122.395303527044) | 10 | 3 | 8 | 58 | 1 | ||||
121579 | 28693 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2831 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6011382.0585 | 2092413.3588 | 37.7260101978791 | -122.402834154918 | (37.7260101978791, -122.402834154918) | 10 | 3 | 7 | 309 | 28 | |||
122087 | 201954 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013442.87747 | 2092521.69328 | 37.7264225169742 | -122.39571757043 | (37.7264225169742, -122.39571757043) | 10 | 3 | 8 | 58 | 1 | ||||
122213 | 201959 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013611.93871 | 2092388.91632 | 37.7260673414157 | -122.39512383262 | (37.7260673414157, -122.39512383262) | 10 | 3 | 8 | 58 | 1 | ||||
122819 | 187411 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3030 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011609.4215 | 2091501.0153 | 37.7235177829206 | -122.401984062824 | (37.7235177829206, -122.401984062824) | 10 | 3 | 7 | 309 | 28 | |||
124662 | 187433 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3101 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011778.4324 | 2091121.7264 | 37.7224857645729 | -122.401373176758 | (37.7224857645729, -122.401373176758) | 10 | 3 | 7 | 309 | 28 | |||
125175 | 24938 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2424 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/2008 12:00:00 AM | 3 | 3X3 | 6010672.3635 | 2094555.631 | 37.7318527757006 | -122.40543834332 | (37.7318527757006, -122.40543834332) | 10 | 3 | 7 | 309 | 28 | ||
127112 | 187430 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3099 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011745.3136 | 2091225.2883 | 37.7227682764898 | -122.401494936414 | (37.7227682764898, -122.401494936414) | 10 | 3 | 7 | 309 | 28 | |||
129450 | 220538 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 374 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005466.32176 | 2101534.69064 | 37.750723233794 | -122.423932831058 | (37.750723233794, -122.423932831058) | 2 | 4 | 5 | 28859 | 19 | |||
132246 | 24861 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 5 | 3x3 | 6010982.267 | 2093558.4742 | 37.7291321150259 | -122.404296778298 | (37.7291321150259, -122.404296778298) | 10 | 3 | 7 | 309 | 28 | ||
132303 | 187432 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3101 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | |||
132859 | 201953 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013419.73856 | 2092537.06748 | 37.7264634442079 | -122.395798637991 | (37.7264634442079, -122.395798637991) | 10 | 3 | 8 | 58 | 1 | ||||
133213 | 87545 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2775 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2009 12:00:00 AM | 3 | 6011301.1014 | 2092680.4118 | 37.72673894939 | -122.403132796502 | (37.72673894939, -122.403132796502) | 10 | 3 | 7 | 309 | 28 | |||
134571 | 87413 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2426 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010682.1739 | 2094526.9006 | 37.7317744366076 | -122.405402403953 | (37.7317744366076, -122.405402403953) | 10 | 3 | 7 | 309 | 28 | |||
135430 | 187426 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2975 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6011568.6802 | 2091804.6041 | 37.7243491014753 | -122.402146232517 | (37.7243491014753, -122.402146232517) | 10 | 3 | 7 | 309 | 28 | |||
135757 | 83305 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 98 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52352 | 6014318.2598 | 2094125.44154 | 37.7308747429648 | -122.392803536763 | (37.7308747429648, -122.392803536763) | 10 | 3 | 8 | 58 | 1 | |
136182 | 87536 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2555 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010977.5362 | 2093738.3729 | 37.7296258148798 | -122.404325790259 | (37.7296258148798, -122.404325790259) | 10 | 3 | 7 | 309 | 28 | |||
137334 | 250141 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2550x Lyon St | 9 | Median : Yard | Tree | DPW 1 | 8 | 5999216.75628 | 2117624.14446 | 37.7945459731801 | -122.446701808162 | (37.7945459731801, -122.446701808162) | 13 | 9 | 1 | 57 | 27 | ||||
138416 | 87530 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3056 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011629.9236 | 2091431.6235 | 37.7233283915075 | -122.4019083147 | (37.7233283915075, -122.4019083147) | 10 | 3 | 7 | 309 | 28 | ||||
138521 | 24908 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2910 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2000 12:00:00 AM | 3 | 2X2 | 6011455.3929 | 2092008.3109 | 37.7249021144111 | -122.402552170924 | (37.7249021144111, -122.402552170924) | 10 | 3 | 7 | 309 | 28 | ||
139759 | 189125 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1900 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011631.63205 | 2106077.72032 | 37.7635435282439 | -122.402932028116 | (37.7635435282439, -122.402932028116) | 8 | 3 | 8 | 28856 | 29 | |||
140891 | 220536 | Undocumented 4 | Acer x freemanii :: Freeman Maple 276 | 688 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007465.47694 | 2105646.02383 | 37.7621246732254 | -122.41731088 | (37.7621246732254, -122.41731088) | 8 | 4 | 7 | 28859 | 19 | |||
149521 | 43900 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 647 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 8 | Permit Number 43502 | 6014447.84015 | 2104062.96153 | 37.7581682911444 | -122.393050603011 | (37.7581682911444, -122.393050603011) | 10 | 3 | 8 | 28856 | 29 | ||
150015 | 201958 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013578.92105 | 2092400.91485 | 37.7260984507597 | -122.395238813615 | (37.7260984507597, -122.395238813615) | 10 | 3 | 8 | 58 | 1 | ||||
151015 | 87523 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2550 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6010949.6824 | 2093662.1841 | 37.7294150598462 | -122.404416723577 | (37.7294150598462, -122.404416723577) | 10 | 3 | 7 | 309 | 28 | |||
151115 | 87414 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2460 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6010776.0734 | 2094217.1723 | 37.7309292375661 | -122.405055971835 | (37.7309292375661, -122.405055971835) | 10 | 3 | 7 | 309 | 28 | |||
151611 | 87539 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2565 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010996.4612 | 2093670.0325 | 37.7294392239589 | -122.40425555613 | (37.7294392239589, -122.40425555613) | 10 | 3 | 7 | 309 | 28 | |||
152032 | 187418 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2658 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011087.5113 | 2093204.6922 | 37.728166583911 | -122.403908052633 | (37.728166583911, -122.403908052633) | 10 | 3 | 7 | 309 | 28 | |||
152796 | 187413 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2816 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6011315.8209 | 2092461.197 | 37.7261378529483 | -122.403066498764 | (37.7261378529483, -122.403066498764) | 10 | 3 | 7 | 309 | 28 | |||
154732 | 24856 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2462 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2001 12:00:00 AM | 6 | 3X3 | 6010790.0883 | 2094178.6315 | 37.7308241960832 | -122.405004807114 | (37.7308241960832, -122.405004807114) | 10 | 3 | 7 | 309 | 28 | ||
156313 | 124495 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2722 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 5996528.61927 | 2111303.84545 | 37.7770381965497 | -122.455546010516 | (37.7770381965497, -122.455546010516) | 11 | 6 | 2 | 54 | 16 | |||
159441 | 220531 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1699 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006577.77787 | 2099808.4311 | 37.7460460028251 | -122.41996682533 | (37.7460460028251, -122.41996682533) | 2 | 7 | 7 | 28859 | 2 | |||
160945 | 24913 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3112 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 3 | 2X3 | 6011716.4004 | 2091155.3709 | 37.7225746842734 | -122.401589972063 | (37.7225746842734, -122.401589972063) | 10 | 3 | 7 | 309 | 28 | ||
162254 | 28690 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2857 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6011409.3946 | 2092320.3108 | 37.7257562336227 | -122.402733114399 | (37.7257562336227, -122.402733114399) | 10 | 3 | 7 | 309 | 28 | |||
165228 | 28707 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3054 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6011625.7181 | 2091444.2402 | 37.7233627996702 | -122.401923738891 | (37.7233627996702, -122.401923738891) | 10 | 3 | 7 | 309 | 28 | |||
165678 | 24915 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3166 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 3 | 2X3 | 6011780.5352 | 2090937.2075 | 37.7219792306681 | -122.401352947061 | (37.7219792306681, -122.401352947061) | 10 | 3 | 7 | 309 | 28 | ||
167312 | 24860 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1996 12:00:00 AM | 6 | 3X3 | 6010972.8069 | 2093591.7595 | 37.7292229808684 | -122.404331824669 | (37.7292229808684, -122.404331824669) | 10 | 3 | 7 | 309 | 28 | ||
167892 | 201955 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1650 Carroll Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013434.02525 | 2092502.61438 | 37.7263696377445 | -122.395746836146 | (37.7263696377445, -122.395746836146) | 10 | 3 | 8 | 58 | 1 | ||||
170698 | 187435 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2442 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010729.1237 | 2094388.8543 | 37.7313980155066 | -122.405230370585 | (37.7313980155066, -122.405230370585) | 10 | 3 | 7 | 309 | 28 | |||
171737 | 87546 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2755 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x3 | 6011273.5025 | 2092768.4657 | 37.726979185823 | -122.403234397065 | (37.726979185823, -122.403234397065) | 10 | 3 | 7 | 309 | 28 | |||
173149 | 24877 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2495 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010876.8656 | 2094065.618 | 37.7305187352607 | -122.404696849479 | (37.7305187352607, -122.404696849479) | 10 | 3 | 7 | 309 | 28 | |||
173328 | 24878 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2481 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1996 12:00:00 AM | 3 | 3X3 | 6010849.5295 | 2094153.9347 | 37.7307597064795 | -122.404797570212 | (37.7307597064795, -122.404797570212) | 10 | 3 | 7 | 309 | 28 | ||
174181 | 220530 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1699 Valencia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006575.50845 | 2099843.92324 | 37.7461433283579 | -122.419977190911 | (37.7461433283579, -122.419977190911) | 2 | 7 | 7 | 28859 | 2 | |||
177205 | 220532 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1699 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006578.5798 | 2099792.744 | 37.7460029747753 | -122.419962939345 | (37.7460029747753, -122.419962939345) | 2 | 7 | 7 | 28859 | 2 | |||
179406 | 220537 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2852 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009808.64587 | 2100761.17701 | 37.7488435293156 | -122.408862066847 | (37.7488435293156, -122.408862066847) | 2 | 4 | 7 | 28859 | 19 | |||
179690 | 43899 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 643 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 7 | Permit Number 43501 | 6014443.19384 | 2104094.64498 | 37.7582550289619 | -122.393068888926 | (37.7582550289619, -122.393068888926) | 10 | 3 | 8 | 28856 | 29 | ||
179913 | 24885 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2785 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1997 12:00:00 AM | 6 | 3X3 | 6011314.2438 | 2092633.625 | 37.7266112164681 | -122.403084073838 | (37.7266112164681, -122.403084073838) | 10 | 3 | 7 | 309 | 28 | ||
180343 | 187420 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2613 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6011096.6061 | 2093351.1986 | 37.7285693680627 | -122.403886916628 | (37.7285693680627, -122.403886916628) | 10 | 3 | 7 | 309 | 28 | |||
181462 | 187429 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 3101 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6011760.5588 | 2091178.5014 | 37.7226406598622 | -122.401438950199 | (37.7226406598622, -122.401438950199) | 10 | 3 | 7 | 309 | 28 | |||
184837 | 87417 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2480 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6010829.3299 | 2094055.3008 | 37.7304877494342 | -122.404860462101 | (37.7304877494342, -122.404860462101) | 10 | 3 | 7 | 309 | 28 | |||
187574 | 2401 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2706 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6009764.79171 | 2101547.21591 | 37.7509993616312 | -122.409069170817 | (37.7509993616312, -122.409069170817) | 2 | 4 | 7 | 28859 | 19 | |||
188922 | 187437 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2565 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010991.73 | 2093688.9575 | 37.729490923677 | -122.404273243903 | (37.729490923677, -122.404273243903) | 10 | 3 | 7 | 309 | 28 | |||
189086 | 189126 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 1900 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011605.13386 | 2106076.73063 | 37.7635393310953 | -122.403023607854 | (37.7635393310953, -122.403023607854) | 8 | 3 | 8 | 28856 | 29 | |||
193428 | 28660 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 2544 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 5 | 3x3 | 6010930.7624 | 2093726.3021 | 37.7295900571246 | -122.4044866437 | (37.7295900571246, -122.4044866437) | 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) );